civicrm_mailing_component

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_mailing.footer_id FK_civicrm_mailing_footer_idN
civicrm_mailing.header_id FK_civicrm_mailing_header_idN
civicrm_mailing.optout_id FK_civicrm_mailing_optout_idN
civicrm_mailing.reply_id FK_civicrm_mailing_reply_idN
civicrm_mailing.unsubscribe_id FK_civicrm_mailing_unsubscribe_idN
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?

Indexes

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

Relationships

Close relationships within degrees of separation