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_emailtext
This field generally contains one mail address, but it is also permitted to have several addreses separated by commas
csv_datatext
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).
sentcharacter(1)
'Y' if the message for this recipient has been sent, NULL otherwise.