Summary of the "moderate_" fields in ListManager
The moderate_ table holds messages that need to be moderated, or are set to be released at a particular time.
When a message is received it will start with an inmail_ record. If the message needs approval, the record will be copied to the moderate_ table. When it is approved (if it is not also rescheduled) it is copied again to the inmail_ table as an approved message.
Primary key: MessageID_
Field Name |
Description |
Version Added |
---|---|---|
AutoApDate_ |
Date/time at which time this message is automatically approved (smalldatetime, NULL) |
|
Body_ |
The body of the message (text, NULL) |
|
ByEmail_ |
Was this current entry created by email, or by some other means, such as a script or web interface (bool) |
|
DeliverBefore_ |
After this time the message should not be delivered. (smalldatetime, NULL) |
|
DetectHTML_ |
Should this message detect HTML use. (bool) |
9.2 |
DocID_ |
DocID_ of content that this inmail message uses. Reserved for future use. (int, NULL) |
9.2 |
DocType_ |
DocType_ of content that this inmail message uses. (varchar(20), NULL) |
9.2 |
GuiState_ |
Details about the state of the edit control in the GUI. (text, null) |
|
HdrAll_ |
The complete message header (text, NULL) |
|
HdrDate_ |
The 'date:' header (varchar(100), NULL) |
|
HdrFrom_ |
The 'from:' header (varchar(200), NULL) |
|
HdrFromSpc_ |
The 'from ' header (varchar(200), NULL) |
|
HdrSubject_ |
The 'subject:' header (varchar(2001000), NULL) |
|
HdrTo_ |
The 'to:' header (varchar(200), NULL) |
|
IsAutoApprove_ |
Whether or not this message will be auto-approved at a specific date/time. (bool, NOT NULL). |
Added in 8.1. |
List_ |
The list that this message belongs to (varchar(60), NOT NULL) |
|
MailStreamID_ | The MailStream associated with this Mailing (int, NULL) | 10.0 |
MaxRecips_ |
For a list posting, the maximum number of recipients allowed to get this message. ListManager will remove any members over this limit. If this field is not set, then there is no max. (int, NOT NULL) |
|
MemberID_ |
MemberID of the user who contributed this moderated message (int, NOT NULL) |
|
MessageID_ |
Unique message ID (int, Identity, NOT NULL) |
|
ModHdrDate_ |
If set, this moderated message should have its Date: header rewritten to be the date/time it is approved, removing the original Date: header stamp (char(1), NOT NULL) |
|
PurgeMess_ |
For a list posting, indicates that the posting should remove recipients who have received the following archived Message IDs. A space-separated list of IDs. (text, NULL) |
|
ReSubmit_ |
If set, means that when the message is approved, it should be resubmitted for automatic approval after so many hours (smallint, NOT NULL) |
|
Status_ |
Status of the message: new, processed (varchar(20), 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) |
|
SubsetID_ |
The ID of the subset used to create this message. NULL or 0 if no subset was used. (int, NULL) |
|
SuppressionList_ |
List of email addresses (CRLF delimited) not to send this mailing. (text, NULL) |
Added in 8.8 |
SuppressionListCount_ |
Count of email addresses not to send this mailing. (int, NOT NULL). |
Added in 8.8. |
SynchronizeAfter_ |
If SynchronizeFirst_ is true, this is the oldest allowed date/time of the last synchronization. (datetime, NULL) |
Added in 8.8 |
SynchronizeFirst_ |
Whether or not to ODBC synchronize the member list before sending mailing. (bool, 'F') |
Added in 8.8 |
Title_ |
Optional title given to this posting -- can only be set independently of the message (ie with web posting or with 'moderate' commands (varchar(70), NULL) |
|
To_ |
The email address this message was sent to (varchar(100), NULL) |
|
TrackAllUrls_ |
Should URLs in this message be tracked. (bool) |
9.2 |
TrackOpens_ |
Should opens of this message be tracked. (bool) |
9.2 |
Transact_ |
The log of activity for this message. (text, NULL) |
|
Type_ |
Message type: unknown, command, error-mail, auto-refused, bad-to-address (varchar(20), NULL) |