Table | message_templates |
|---|---|
Description | Message Templates |
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
| co_id | integer, foreign key | CO Record ID | cos:id | | |
description | varchar(128) | Name | | ||
| status | varchar(2) | Status |
| | |
| context | varchar(2) | Message Template context |
| | |
| format | varchar(4) | Type of message body to use with this Template. |
| | |
| subject | varchar(256) | Message subject template | | ||
| body_text | text | Message body template for Plain Text | If format is both or text | ||
| body_html | text | Message body template for HTML | If format is both or html | ||
| cc | varchar(256) | Comma separated list of email addresses to cc when this Message Template is used | |||
| bcc | varchar(256) | Comma separated list of email addresses to bcc when this Message Template is used | |||
| reply_to | varchar(256) | Reply-To address to use when this Message Template is used |