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