Summary of the "outmail_" fields in ListManager
The outmail_ table stores mail jobs that have been approved to be sent. The job may not have been sent yet (new), it may be being sent currently (pending), it may be in-between sending tries (retry), or it may be finished (done). Done records are automatically purged from outmail_ based on the server setting.
Currently all information about the message being sent is stored in the outmail_ table. The members to receive the message are listed in their correct status in the ID_xxx columns by their MemberID, with spaces separating each Member ID. Most jobs should only have data in the ID_xxx columns, since ListManager is only able to mail merge, unsubscribe, etc. recipients who are members. But the E_xxx columns store information by email address, separated by carriage returns, of the recipients who should receive this message. These fields should only be populated for auto-responders or other small mailings where the recipient is not a member.
There is no restriction that the Member IDs be all from a single list, but the List_ column defines what list settings will be used for mail merging.
Primary key: MessageID_
|
Body_ |
The body of the message (text, NULL) |
|
Created_ |
Date the message was entered in the queue (datetime, NOT NULL) |
|
E_Success_ |
Recipients who have received this email message (Text, NULL) |
|
E_SuccessCount_ |
Number of recipients in the E_Success_ column. (int, NOT NULL) |
|
E_ToSend_ |
Complete list of recipients of this email message. Gets slowly drained as the message delivery proceeds (Text, NULL) |
|
E_ToSendCount_ |
Number of recipients in the E_ToSend_ column. (int, NOT NULL) |
|
E_Trans_ |
Member id of recipients where delivery was attempted, but failed due to a transient error, such as a tcp/ip timeout (Text, NULL) |
|
E_TransCount_ |
Number of recipients in the E_Trans_ column. (int, NOT NULL) |
|
E_Unreach_ |
Recipients where delivery was attempted, but it's unlikely we'll ever reach this person (Text, NULL) |
|
E_UnreachCount_ |
Number of recipients in the E_Unreach column. (int, NOT NULL) |
|
Finished_ |
The date and time this message was 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) |
|
ID_Success_ |
Member id of recipients who have received this email message (Text, NULL) |
|
ID_SuccessCount_ |
Number of recipients in the ID_Success_ column. (int, NOT NULL) |
|
ID_ToSend_ |
Member ID of complete list of recipients of this email message. Gets slowly drained as the message delivery proceeds (Text, NULL) |
|
ID_ToSendCount_ |
Number of recipients in the ID_ToSend_ column. (int, NOT NULL) |
|
ID_Trans_ |
Member id of recipients where delivery was attempted, but failed due to a transient error, such as a tcp/ip timeout (Text, NULL) |
|
ID_TransCount_ |
Number of recipients in the ID_Trans_ column. (int, NOT NULL) |
|
ID_Unreach_ |
Member id of recipients where delivery was attempted, but it's unlikely we'll ever reach this person (Text, NULL) |
|
ID_UnreachCount_ |
Number of recipients in the ID_Unreach column. (int, NOT 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_ |
The relative importance of processing this outgoing message (tinyint, NOT NULL) |
|
RetryTime_ |
The time to next retry this message send (smalldatetime, NULL) |
|
SendDate_ |
The date this message should be sent. For new messages, this is blank. For messages that fail once, they are rescheduled for the text day (smalldatetime, NULL) |
|
SendTry_ |
The number of times we have attempted to send this message (tinyint, NOT NULL) |
|
Status_ |
Status of the message: processed, pending, new, retry, done (varchar(20), NOT NULL) |
|
SubsetID_ |
The ID of the subset used to create this entry. NULL or 0 if no subset was used. (int, 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) |
|
|