contact

87 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
contact_customer.contact_id FK_1B1C129EE7A1254AC
contact_user.contact_id FK_A56C54B6E7A1254AC
contactmessage.contact_id FK_DF1CE07DE7A1254AR
timetracking.contact_id FK_88B32207E7A1254AR
customer_id VARCHAR 36 null
customer.id FK_4C62E6389395C3F3R
client_id VARCHAR 36 null
client.id FK_4C62E63819EB6921R
subject TINYTEXT 255 null
ticketNumber INT 10 null
wasread BIT 1 null
hasAttachments BIT 1 null
flagged BIT 1 null
lastReply DATETIME 19 null
status_id VARCHAR 36 null
entitystatus.id FK_4C62E6386BF700BDR
order_id VARCHAR 36 null
orders.id FK_4C62E6388D9F6D38R
subscriptionContract_id VARCHAR 36 null
subscriptioncontract.id FK_4C62E638244DF37R
contactClerk_id INT 10 null
users.id FK_4C62E638CE4DBD6CR
foreignId VARCHAR 36 null
customerNote LONGTEXT 2147483647 null
internalNote LONGTEXT 2147483647 null
estimatedFulfillmentDate VARCHAR 255 null
estimatedFulfillmentCosts VARCHAR 255 null
fulfillmentBeginDate DATETIME 19 null
fulfillmentEndDate DATETIME 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
foreignId_idx Performance Asc foreignId
IDX_4C62E63819EB6921 Performance Asc client_id
IDX_4C62E638244DF37 Performance Asc subscriptionContract_id
IDX_4C62E6386BF700BD Performance Asc status_id
IDX_4C62E6388D9F6D38 Performance Asc order_id
IDX_4C62E6389395C3F3 Performance Asc customer_id
IDX_4C62E638CE4DBD6C Performance Asc contactClerk_id
ticketNumber_idx Performance Asc ticketNumber

Relationships