civicrm_msg_template

48 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_action_schedule.msg_template_id FK_civicrm_action_schedule_msg_template_idN
civicrm_action_schedule.sms_template_id FK_civicrm_action_schedule_sms_template_idN
civicrm_mailing.msg_template_id FK_civicrm_mailing_msg_template_idN
civicrm_mosaico_msg_template.msg_tpl_id FK_civicrm_mosaico_msg_template_msg_tpl_idC
civicrm_mosaico_template.msg_tpl_id FK_civicrm_mosaico_template_msg_tpl_idN

Message Template ID
msg_title VARCHAR 255 √ null

Descriptive title of message
msg_subject TEXT 65535 √ null

Subject for email message.
msg_text LONGTEXT 2147483647 √ null

Text formatted message
msg_html LONGTEXT 2147483647 √ null

HTML formatted message
is_active TINYINT 3 √ 1
workflow_id INT UNSIGNED 10 √ null

a pseudo-FK to civicrm_option_value
is_default TINYINT 3 √ 1

is this the default message template for the workflow referenced by workflow_id?
is_reserved TINYINT 3 √ null

is this the reserved message template which we ship for the workflow referenced by workflow_id?
pdf_format_id INT UNSIGNED 10 √ null

a pseudo-FK to civicrm_option_value containing PDF Page Format.
is_sms TINYINT 3 √ 0

Is this message template used for sms?

Indexes

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

Relationships

Close relationships within degrees of separation