civicrm_mailing_component


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
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

Indexes

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

Relationships