emails


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
emails_email_addr_rel.email_id Defined in XMLR
notes.email_id Defined in XMLR
tag_bean_rel.bean_id Defined in XMLR
emails_beans.email_id Defined in XMLR
campaign_log.related_id Defined in XMLR
date_entered DATETIME 19 √ null
date_modified DATETIME 19 √ null
assigned_user_id CHAR 36 √ null
users.id Defined in XMLR
modified_user_id CHAR 36 √ null
users.id Defined in XMLR
created_by CHAR 36 √ null
users.id Defined in XMLR
deleted BIT 1 √ 0
date_sent DATETIME 19 √ null
message_id VARCHAR 255 √ null
message_uid VARCHAR 64 √ null
name VARCHAR 255 √ null
type VARCHAR 100 √ null
status VARCHAR 100 √ null
flagged BIT 1 √ 0
reply_to_status BIT 1 √ 0
intent VARCHAR 100 √ pick
mailbox_id CHAR 36 √ null
inbound_email.id Defined in XMLR
state VARCHAR 100 Archived
reply_to_id CHAR 36 √ null
parent_type VARCHAR 255 √ null
parent_id CHAR 36 √ null
leads.id Defined in XMLR
bugs.id Defined in XMLR
prospects.id Defined in XMLR
opportunities.id Defined in XMLR
project_task.id Defined in XMLR
project.id Defined in XMLR
accounts.id Defined in XMLR
cases.id Defined in XMLR
quotes.id Defined in XMLR
direction VARCHAR 20 Unknown
total_attachments INT 10 √ null
outbound_email_id CHAR 36 √ null
sync_key VARCHAR 100 √ null
team_id CHAR 36 √ null
teams.id Defined in XMLR
team_set_id CHAR 36 √ null
team_sets_teams.team_set_id Defined in XMLR
team_sets.id Defined in XMLR
acl_team_set_id CHAR 36 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_date_modified Performance Asc date_modified
idx_email_assigned Performance Asc/Asc/Asc assigned_user_id + type + status
idx_email_name Performance Asc name
idx_email_parent_id Performance Asc parent_id
idx_emails_acl_tmst_id Performance Asc/Asc acl_team_set_id + deleted
idx_emails_skey Must be unique Asc sync_key
idx_emails_tmst_id Performance Asc/Asc team_set_id + deleted
idx_mailbox_id Performance Asc mailbox_id
idx_message_id Performance Asc message_id
idx_state Performance Asc/Asc state + id

Relationships

Close relationships within degrees of separation