Structure of mailing_definition

mailing_id

serial PRIMARY KEY

Unique identifier of the mailing.

title

text

Title of the mailing.

sender_email

text

The email address used as the sender of the outgoing messages.

creation_date

timestamp with time zone DEFAULT now()

The date and time of the insertion of the mailing.

end_date

timestamp with time zone

The date and time at which all the outgoing messages related to this mailing have been sent.

text_template

text

The text/plain part of the body, not yet encoded for SMTP transport. It can be empty if the message format is HTML only.

html_template

text

The html/text part of the body, not yet encoded for SMTP transport. It can be empty if the message format is text only.

header_template

text

A model for the header of the outgoing messages, not yet encoded for SMTP transport.

csv_columns

text

If the mailing comes with a CSV data file, this field contains a comma-separated list of the column names. Column names may be enclosed inside double quotes if necessary.