Table d47civi_0z3xa.civicrm_email Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_group_contact.email_id FK_civicrm_group_contact_email_id R
civicrm_loc_block.email_2_id FK_civicrm_loc_block_email_2_id N
civicrm_loc_block.email_id FK_civicrm_loc_block_email_id N
civicrm_mailing_event_queue.email_id FK_civicrm_mailing_event_queue_email_id N
civicrm_mailing_recipients.email_id FK_civicrm_mailing_recipients_email_id N
Unique Email ID
contact_id int unsigned 10  √  null
civicrm_contact.id FK_civicrm_email_contact_id C
FK to Contact ID
location_type_id int unsigned 10  √  null Which Location does this email belong to.
email varchar 254  √  null Email address
is_primary tinyint 3  √  0 Is this the primary?
is_billing tinyint 3  √  0 Is this the billing?
on_hold tinyint 3 0 Is this address on bounce hold?
is_bulkmail tinyint 3 0 Is this address for bulk mail ?
hold_date datetime 19  √  null When the address went on bounce hold
reset_date datetime 19  √  null When the address bounce status was last reset
signature_text text 65535  √  null Text formatted signature for the email.
signature_html text 65535  √  null HTML formatted signature for the email.

Table contained 185 rows at mer. avr. 13 16:52 EDT 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
contact_id Performance Asc FK_civicrm_email_contact_id
is_billing Performance Asc index_is_billing
is_primary Performance Asc index_is_primary
location_type_id Performance Asc index_location_type
email Performance Asc UI_email

Close relationships  within of separation: