email_addr_bean_rel


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
email_address_id CHAR 36 null
email_addresses.id Defined in XMLR
bean_id CHAR 36 null
accounts.id Defined in XMLR
contacts.id Defined in XMLR
leads.id Defined in XMLR
prospects.id Defined in XMLR
styleguide.id Defined in XMLR
externalusers.id Defined in XMLR
users.id Defined in XMLR
bean_module VARCHAR 100 √ null
primary_address BIT 1 √ 0
reply_to_address BIT 1 √ 0
date_created DATETIME 26 √ null
date_modified DATETIME 26 √ null
deleted BIT 1 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_bean_id Performance Asc/Asc bean_id + bean_module
idx_email_address_bean Performance Asc/Asc/Asc email_address_id + bean_module + bean_id
idx_primary_address_bean Performance Asc/Asc/Asc primary_address + deleted + bean_id

Relationships

Close relationships within degrees of separation