contact

135 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
contact_customer.contact_id FK_1B1C129EE7A1254AC
contact_excludeduser.contact_id FK_20E02005E7A1254AC
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
customerNote2 LONGTEXT 2147483647 √ null
offer_id VARCHAR 36 √ null
offer.id FK_4C62E63853C674EER
timeTrackingAllowed BIT 1 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_4C62E63853C674EE Performance Asc offer_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

Close relationships within degrees of separation