emails_beans


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
email_id CHAR 36 √ null
emails.id Defined in XMLR
bean_id CHAR 36 √ null
accounts.id Defined in XMLR
bugs.id Defined in XMLR
cases.id Defined in XMLR
contacts.id Defined in XMLR
escalations.id Defined in XMLR
leads.id Defined in XMLR
messages.id Defined in XMLR
notes.id Defined in XMLR
opportunities.id Defined in XMLR
products.id Defined in XMLR
project.id Defined in XMLR
project_task.id Defined in XMLR
prospects.id Defined in XMLR
purchased_line_items.id Defined in XMLR
purchases.id Defined in XMLR
quotes.id Defined in XMLR
revenue_line_items.id Defined in XMLR
tasks.id Defined in XMLR
users.id Defined in XMLR
bean_module VARCHAR 100 √ null
campaign_data TEXT 65535 √ null
date_modified DATETIME 26 √ null
deleted BIT 1 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_emails_beans_bean_id Performance Asc bean_id
idx_emails_beans_email_bean Performance Asc/Asc/Asc email_id + bean_id + deleted

Relationships

Close relationships within degrees of separation