Manitou-Mail Home

22.  Table: mail_template

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_id

serial

Unique identifier of the template.

PRIMARY KEY

title

text

The title of the template.

body_text

text

The plain text part of the template. It can be null if the format is HTML only.

body_html

text

The HTML text part of the template. It can be null if the format is plain text only.

header

text

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_date

timestamp with time zone

The date and time at which the template was created.

DEFAULT now()