Summary of the "messages_" fields in ListManager
The messages_ table stores the archive of all message postings. This data is required to search for messages. It is also used for NNTP and RSS access to messages.
Primary key: MessageID_
|
Field Name |
Description |
Version Added |
|---|---|---|
|
Body_ |
The body of the message (text, NULL) |
|
|
CreatStamp_ |
Date/time stamp this message was created (smalldatetime, NOT NULL) |
|
|
Digested_ |
Has this message been sent in a digest yet? (char(1), NOT 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(1000), NULL) |
|
|
HdrTo_ |
The 'to:' header (varchar(200), NULL) |
|
|
List_ |
The list that this message belongs to (varchar(60), NOT NULL) |
|
|
MemberID_ |
Unique member ID of the member who posted this message (int, NOT NULL) |
|
|
MessageID_ |
Unique message ID (int, primary key, identity, NOT NULL) |
|
|
ParentID_ |
The message thread that this message is responding to, or the ID of this message, if this is the start of a thread. (int, NULL) |
|
|
SubsetID_ |
The ID of the subset used to create this message. NULL or 0 if no subset used. (int, NULL) |
|
|
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) |