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 lyrCompletedRecipsas 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_
Field Name |
Description |
Version Added |
ArchiveMessageID_ |
Foreign key to the messages_ table where list postings are archived. (int, NULL) |
Added in 8.95 |
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) |
|
DocID_ |
DocID_ of content that this message uses. Reserved for future use. (int, NULL) |
9.2 |
DocType_ |
DocType_ of content that this message uses. (varchar(20), NULL) |
9.2 |
From_ |
Who the email message is to be from (an email address) (varchar(200), NULL) |
|
HasCreatedMailingLinks_
|
char(1), NOT NULL
|
9.3
|
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) |
|
MailStreamID_ | The Mail Stream associated with this Mailing (int, NULL) | 10.0 |
MessageID_ |
Unique message ID (int, Identity, NOT NULL) |
|
Priority_ |
Currently unused. (tinyint, NOT NULL) |
|
SplitPartID_ |
The ID of the SplitTest this record is for. NULL or 0 if this record is not part of a splittest. (int, NULL) |
|
SplitTestID_ |
The ID of the SplitTest this record is for. NULL or 0 if this record is not part of a splittest. (int, NULL) |
|
Subject_
|
varchar(200), NULL
|
9.3
|
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) |
|