civicrm_mailing


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_mailing_group.mailing_id FK_civicrm_mailing_group_mailing_id C
civicrm_mailing_job.mailing_id FK_civicrm_mailing_job_mailing_id C
civicrm_mailing_recipients.mailing_id FK_civicrm_mailing_recipients_mailing_id C
civicrm_mailing_trackable_url.mailing_id FK_civicrm_mailing_trackable_url_mailing_id C
domain_id INT UNSIGNED 10 null
civicrm_domain.id FK_civicrm_mailing_domain_id N

Which site is this mailing for

header_id INT UNSIGNED 10 null
civicrm_mailing_component.id FK_civicrm_mailing_header_id N

FK to the header component.

footer_id INT UNSIGNED 10 null
civicrm_mailing_component.id FK_civicrm_mailing_footer_id N

FK to the footer component.

reply_id INT UNSIGNED 10 null
civicrm_mailing_component.id FK_civicrm_mailing_reply_id N

FK to the auto-responder component.

unsubscribe_id INT UNSIGNED 10 null
civicrm_mailing_component.id FK_civicrm_mailing_unsubscribe_id N

FK to the unsubscribe component.

resubscribe_id INT UNSIGNED 10 null
optout_id INT UNSIGNED 10 null
civicrm_mailing_component.id FK_civicrm_mailing_optout_id N

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
civicrm_msg_template.id FK_civicrm_mailing_msg_template_id N

FK to the message template.

override_verp TINYINT 3 0

Should we overrite VERP address in Reply-To

created_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_mailing_created_id N

FK to Contact ID who first created this mailing

created_date DATETIME 19 null

Date and time this mailing was created.

scheduled_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_mailing_scheduled_id N

FK to Contact ID who scheduled this mailing

scheduled_date DATETIME 19 null

Date and time this mailing was scheduled.

approver_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_mailing_approver_id N

FK to Contact ID who approved this mailing

approval_date DATETIME 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
civicrm_campaign.id FK_civicrm_mailing_campaign_id N

The campaign for which this mailing has been initiated.

dedupe_email TINYINT 3 0

Remove duplicate emails?

sms_provider_id INT UNSIGNED 10 null
civicrm_sms_provider.id FK_civicrm_mailing_sms_provider_id N
hash VARCHAR 16 null

Key for validating requests related to this mailing.

location_type_id INT UNSIGNED 10 null
civicrm_location_type.id FK_civicrm_mailing_location_type_id N

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.

Table contained 0 rows

Indexes

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

Relationships