Table d47civi_0z3xa.civicrm_mailing 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_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.
mailing_type varchar 32  √  null differentiate between standalone mailings, A/B tests, and A/B final-winner
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.

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
approver_id Performance Asc FK_civicrm_mailing_approver_id
campaign_id Performance Asc FK_civicrm_mailing_campaign_id
created_id Performance Asc FK_civicrm_mailing_created_id
domain_id Performance Asc FK_civicrm_mailing_domain_id
footer_id Performance Asc FK_civicrm_mailing_footer_id
header_id Performance Asc FK_civicrm_mailing_header_id
location_type_id Performance Asc FK_civicrm_mailing_location_type_id
msg_template_id Performance Asc FK_civicrm_mailing_msg_template_id
optout_id Performance Asc FK_civicrm_mailing_optout_id
reply_id Performance Asc FK_civicrm_mailing_reply_id
scheduled_id Performance Asc FK_civicrm_mailing_scheduled_id
sms_provider_id Performance Asc FK_civicrm_mailing_sms_provider_id
unsubscribe_id Performance Asc FK_civicrm_mailing_unsubscribe_id
hash Performance Asc index_hash

Close relationships  within of separation: