| id |
char(36)
|
utf8mb4_general_ci
|
|
|
| name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| date_entered |
datetime
|
|
|
|
| date_modified |
datetime
|
|
|
|
| modified_user_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| created_by |
char(36)
|
utf8mb4_general_ci
|
|
|
| deleted |
tinyint(1)
|
|
|
|
| assigned_user_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| orphaned |
tinyint(1)
|
|
|
|
| last_synced |
datetime
|
|
|
|
| date_sent_received |
datetime
|
|
|
|
| message_id |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| type |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| status |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| flagged |
tinyint(1)
|
|
|
|
| reply_to_status |
tinyint(1)
|
|
|
|
| intent |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| mailbox_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| parent_type |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| parent_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| uid |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| category_id |
varchar(100)
|
utf8mb4_general_ci
|
|
|
