civicrm_mailing_component - civicrm Database

Columns

Related columns Constraint Comments

Search:

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?

Showing 1 to 8 of 8 entries

Indexes

Search:

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

Showing 1 to 1 of 1 entries

Relationships

Close relationships within degrees of separation

One
Two degrees