ticketdata

211 rows

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

TicketDataID

INT

10

√

null

TicketID

INT

10

null

tickets.TicketID

Implied ConstraintR

DataType

INT

10

0

Data

MEDIUMTEXT

16777215

null

Attachment

LONGBLOB

2147483647

null

Address

VARCHAR

100

null

UserID

INT

10

0

TicketDataDate

TIMESTAMP

19

CURRENT_TIMESTAMP

Showing 1 to 8 of 8 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	TicketDataID
TicketDataDate	Performance	Asc	TicketDataDate
tid_datatype	Performance	Asc/Asc	TicketID + DataType
UserID	Performance	Asc	UserID

Showing 1 to 4 of 4 entries

Relationships

Close relationships within degrees of separation