orderinternalcomment

48 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
user_id INT 10 √ null
users.id FK_76487907A76ED395R
order_id VARCHAR 36 √ null
orders.id FK_764879078D9F6D38R
message LONGTEXT 2147483647 √ null
created DATETIME 19 null
file VARCHAR 255 √ null
lastupdated INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_764879078D9F6D38 Performance Asc order_id
IDX_76487907A76ED395 Performance Asc user_id

Relationships

Close relationships within degrees of separation