This table contains pre-created messages that can be used as models when composing a new mail or setting up a mailing. Templates may contain placeholders for variable text.
Structure of mail_template
template_idserial
Unique identifier of the template.
PRIMARY KEY
titletext
The title of the template.
body_texttext
The plain text part of the template. It can be null if the format is HTML only.
body_htmltext
The HTML text part of the template. It can be null if the format is plain text only.
headertext
The header part of the template, not yet encoded for the mail transport. It may contain characters outside of the US-ASCII charset and unfolded long lines. Entries are separated by newlines. In a future version, the contents of this field may be added to the headers of an outgoing message that would have been generated from this template.
creation_datetimestamp with time zone
The date and time at which the template was created.
DEFAULT now()