Summary of the "outmail_" fields in ListManager
The outmail_ table stores mail jobs that
have been approved to be sent. Records that do not have any recipient left to deliver are automatically
purged from outmail_ based on the list setting for "Keep mailing and clickthrough data for how many
days".
The outmail_ table stores the message text and information needed to sent the message. The recipients
who will recieve this mail are stored initially in lyrActiveRecips,
and will be moved to lyrCompletedRecips
as they are completed.
With subset postings it is possible to have recipients from multiple lists, but only one list is used
for the purpose of mail merging. That is the value in the List_ column.
Primary key: MessageID_
|
Body_ |
The body of the message (text, NULL) |
|
CheckSum1_ |
A value to represent the content of the message body (int, NULL) |
|
CheckSum2_ |
A value to represent the content of the message body (int, NULL) |
|
CheckSum3_ |
A value to represent the content of the message body (int, NULL) |
|
CheckSum4_ |
A value to represent the content of the message body (int, NULL) |
|
Created_ |
Date the message was entered in the queue (datetime, NOT NULL) |
|
DeliverBefore_ |
After this time the message should not be delivered. (smalldatetime, NULL) |
|
From_ |
Who the email message is to be from (an email address) (varchar(200), NULL) |
|
HdrAll_ |
The complete message header (Text, NULL) |
|
InmailBodySize_ |
The size of the message body from inmail_ (before modifications were made to outmail_) (int, NULL) |
|
InmailHdrFrom_ |
The HdrFrom value from inmail_. Used to detect cross-postings and duplicate postings. (varchar(238), NULL) |
|
InmailID_ |
The ID of the inmail record that created this entry. NULL or 0 if no inmail record exists. (int, NULL) |
|
List_ |
The list that this message belongs to (varchar(60), NULL) |
|
MessageID_ |
Unique message ID (int, Identity, NOT NULL) |
|
Priority_ |
Currently unused. (tinyint, NOT NULL) |
|
Title_ |
Title created by the author for this message. (varchar(70), NULL) |
|
To_ |
Who the message is destined to (an email address) (varchar(200), NULL) |
|
Transact_ |
Transaction log for each record (text, NULL) |
|
Type_ |
Message type: list, error-mail, owner-moderated-posting, owner-mail, debug, index, digest, mdigest, unknown (varchar(50), NOT NULL) |
|
SubsetID_ |
The ID of the subset used to create this entry. NULL or 0 if no subset was used. (int, NULL) |
|
|