contactmessage

191 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
contactmessageattachment.message_id FK_364101B0537A1329R
contact_id VARCHAR 36 null
contact.id FK_DF1CE07DE7A1254AR
subject VARCHAR 255 null
body LONGTEXT 2147483647 null
fromUser VARCHAR 255 null
created DATETIME 19 null
messageType VARCHAR 3 null
medium VARCHAR 10 null
sort INT 10 null
user_id INT 10 null
users.id FK_DF1CE07DA76ED395R
customer_id VARCHAR 36 null
customer.id FK_DF1CE07D9395C3F3R
foreignId VARCHAR 36 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
foreignId_idx Performance Asc foreignId
IDX_DF1CE07D9395C3F3 Performance Asc customer_id
IDX_DF1CE07DA76ED395 Performance Asc user_id
IDX_DF1CE07DE7A1254A Performance Asc contact_id

Relationships