civicrm_email


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
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 4 rows

Indexes

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

Relationships