Table d47civi_0z3xa.civicrm_mailing_component 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.footer_id FK_civicrm_mailing_footer_id N
civicrm_mailing.header_id FK_civicrm_mailing_header_id N
civicrm_mailing.optout_id FK_civicrm_mailing_optout_id N
civicrm_mailing.reply_id FK_civicrm_mailing_reply_id N
civicrm_mailing.unsubscribe_id FK_civicrm_mailing_unsubscribe_id N
name varchar 64  √  null The name of this component
component_type varchar 12  √  null Type of Component.
subject varchar 255  √  null
body_html text 65535  √  null Body of the component in html format.
body_text text 65535  √  null Body of the component in text format.
is_default tinyint 3  √  0 Is this the default component for this component_type?
is_active tinyint 3  √  null Is this property active?

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY

Close relationships  within of separation: