Manitou-Mail Home

23.  Table: mailing_data

The data that corresponds to a mailing. For each mailing, there is one line per recipient, with all the information necessary to generate and send the message to this recipient.

Structure of mailing_data

mailing_data_id

serial PRIMARY KEY

Unique identifier.

mailing_id

integer REFERENCES mailing_definition

The mailing to which this record is related.

recipient_email

text

This field generally contains one mail address, but it is also permitted to have several addreses separated by commas

csv_data

text

If the mailing use mailmerge, this field contains the data in CSV format separated by commas (regardless of the original separator from the CSV file submitted to the user interface).

sent

character(1)

'Y' if the message for this recipient has been sent, NULL otherwise.