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.
Tables referencing mailing_definition via Foreign Key Constraints