Summary of the "inmail_" fields in ListManager

The inmail_ table hold messages received by ListManager. Every received message should be a row in this table, except for some bounce messages, if these are configured to not be saved. The data is saved as soon as it is received, and then is processed as resources are available. Once the message is processed its status is changed to 'done'.

 

Primary key: MessageID_

 

BeingProcessedBy_

The machine name that is currently processing this inmail record. For use in clustering. (varchar(25), 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)

Created_

Date the message was entered in the queue (datetime, NULL)

DeliverBefore_

After this time the message should not be delivered. (smalldatetime, NULL)

HdrAll_

The complete message header (text, NULL)

HdrDate_

The 'date:' header (varchar(100), NULL)

HdrFrom_

The 'from:' header (varchar(238), NULL)

HdrFromSpc_

The 'from' header (varchar(200), NULL)

HdrSubject_

The 'subject:' header (varchar(200), NULL)

HdrTo_

The 'to:' header (varchar(200), NULL)

List_

The list that this message belongs to (varchar(60), NULL)

MaxRecips_

For a list posting, the maximum number of recipients allowed to get this message. ListManager will remove any members so that this max is not reached. (int, NOT NULL)

MessageID_

Unique message ID (int, identity, NOT NULL)

ModerApp_

Has this message been moderation approved? (bool)

NodeID_

The identifier for this node, references into lyrConfigNodeSettings. (int, null)

Priority_

Current unused. (tinyint, NOT NULL)

PurgeMess_

For a list posting, indicates that the posting should remove recipients who have received the following archived message ids. (text, NULL)

Status_

Status of the message: processed (varchar(20), NOT NULL)

SubsetID_

The ID of the subset sent to for this inmail. NULL or 0 if no subset was used. (int, NULL)

Title_

The title of this message (varchar(70), NULL)

To_

The email address this message was sent to (varchar(200), NULL)

Transact_

Transaction log for each record (text, NULL)

Type_

Message type: list, command, error-mail, auto-refused, bad-to-address (varchar(10), NULL)

 

 

  



lyrSpfLevelDescription lyrActiveRecips