| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
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? |
Showing 1 to 11 of 11 entries
