| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
||||||||||
| domain_id | INT UNSIGNED | 10 | √ | null |
|
|
Which site is this mailing for |
|||||||||
| header_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to the header component. |
|||||||||
| footer_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to the footer component. |
|||||||||
| reply_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to the auto-responder component. |
|||||||||
| unsubscribe_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to the unsubscribe component. |
|||||||||
| resubscribe_id | INT UNSIGNED | 10 | √ | null |
|
|
||||||||||
| optout_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to the opt-out component. |
|||||||||
| name | VARCHAR | 128 | √ | null |
|
|
Mailing Name. |
|||||||||
| from_name | VARCHAR | 128 | √ | null |
|
|
From Header of mailing |
|||||||||
| from_email | VARCHAR | 128 | √ | null |
|
|
From Email of mailing |
|||||||||
| replyto_email | VARCHAR | 128 | √ | null |
|
|
Reply-To Email of mailing |
|||||||||
| subject | VARCHAR | 128 | √ | null |
|
|
Subject of mailing |
|||||||||
| body_text | LONGTEXT | 2147483647 | √ | null |
|
|
Body of the mailing in text format. |
|||||||||
| body_html | LONGTEXT | 2147483647 | √ | null |
|
|
Body of the mailing in html format. |
|||||||||
| url_tracking | TINYINT | 3 | √ | null |
|
|
Should we track URL click-throughs for this mailing? |
|||||||||
| forward_replies | TINYINT | 3 | √ | null |
|
|
Should we forward replies back to the author? |
|||||||||
| auto_responder | TINYINT | 3 | √ | null |
|
|
Should we enable the auto-responder? |
|||||||||
| open_tracking | TINYINT | 3 | √ | null |
|
|
Should we track when recipients open/read this mailing? |
|||||||||
| is_completed | TINYINT | 3 | √ | null |
|
|
Has at least one job associated with this mailing finished? |
|||||||||
| msg_template_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to the message template. |
|||||||||
| override_verp | TINYINT | 3 | √ | 0 |
|
|
Should we overrite VERP address in Reply-To |
|||||||||
| created_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to Contact ID who first created this mailing |
|||||||||
| created_date | TIMESTAMP | 19 | √ | null |
|
|
Date and time this mailing was created. |
|||||||||
| scheduled_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to Contact ID who scheduled this mailing |
|||||||||
| scheduled_date | TIMESTAMP | 19 | √ | null |
|
|
Date and time this mailing was scheduled. |
|||||||||
| approver_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to Contact ID who approved this mailing |
|||||||||
| approval_date | TIMESTAMP | 19 | √ | null |
|
|
Date and time this mailing was approved. |
|||||||||
| approval_status_id | INT UNSIGNED | 10 | √ | null |
|
|
The status of this mailing. Values: none, approved, rejected |
|||||||||
| approval_note | LONGTEXT | 2147483647 | √ | null |
|
|
Note behind the decision. |
|||||||||
| is_archived | TINYINT | 3 | √ | 0 |
|
|
Is this mailing archived? |
|||||||||
| visibility | VARCHAR | 40 | √ | Public Pages |
|
|
In what context(s) is the mailing contents visible (online viewing) |
|||||||||
| campaign_id | INT UNSIGNED | 10 | √ | null |
|
|
The campaign for which this mailing has been initiated. |
|||||||||
| dedupe_email | TINYINT | 3 | √ | 0 |
|
|
Remove duplicate emails? |
|||||||||
| sms_provider_id | INT UNSIGNED | 10 | √ | null |
|
|
||||||||||
| hash | VARCHAR | 16 | √ | null |
|
|
Key for validating requests related to this mailing. |
|||||||||
| location_type_id | INT UNSIGNED | 10 | √ | null |
|
|
With email_selection_method, determines which email address to use |
|||||||||
| email_selection_method | VARCHAR | 20 | √ | automatic |
|
|
With location_type_id, determine how to choose the email address to use. |
|||||||||
| mailing_type | VARCHAR | 32 | √ | null |
|
|
differentiate between standalone mailings, A/B tests, and A/B final-winner |
|||||||||
| language | VARCHAR | 5 | √ | null |
|
|
Language of the content of the mailing. Useful for tokens. |
|||||||||
| template_type | VARCHAR | 64 | traditional |
|
|
The language/processing system used for email templates. |
||||||||||
| template_options | LONGTEXT | 2147483647 | √ | null |
|
|
Advanced options used by the email templating system. (JSON encoded) |
|||||||||
| modified_date | TIMESTAMP | 19 | √ | CURRENT_TIMESTAMP |
|
|
When the mailing (or closely related entity) was created or modified or deleted. |
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK_civicrm_mailing_approver_id | Performance | Asc | approver_id |
| FK_civicrm_mailing_campaign_id | Performance | Asc | campaign_id |
| FK_civicrm_mailing_created_id | Performance | Asc | created_id |
| FK_civicrm_mailing_domain_id | Performance | Asc | domain_id |
| FK_civicrm_mailing_footer_id | Performance | Asc | footer_id |
| FK_civicrm_mailing_header_id | Performance | Asc | header_id |
| FK_civicrm_mailing_location_type_id | Performance | Asc | location_type_id |
| FK_civicrm_mailing_msg_template_id | Performance | Asc | msg_template_id |
| FK_civicrm_mailing_optout_id | Performance | Asc | optout_id |
| FK_civicrm_mailing_reply_id | Performance | Asc | reply_id |
| FK_civicrm_mailing_scheduled_id | Performance | Asc | scheduled_id |
| FK_civicrm_mailing_sms_provider_id | Performance | Asc | sms_provider_id |
| FK_civicrm_mailing_unsubscribe_id | Performance | Asc | unsubscribe_id |
| index_hash | Performance | Asc | hash |
