8 rows


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?


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