Table d44civi_9xzwf.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.
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 enum 25  √  User and User Admin Only 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

Table contained 0 rows at Wed Nov 11 17:14 EST 2015

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
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

Close relationships  within of separation: