Summary of the "log_" fields in ListManager
The log_ table keep a record of every email send out by ListManager, except single recipient mail such as subscription confirmations or hello documents. This data is mainly interesting to administrators but is also used by the Lyris ListManager billing program.
Primary key: LogID_
|
Body_ |
The body text of this log entry, if applicable (text, NULL) |
|
ByteCount_ |
The size of the message, in bytes. (int, NULL) |
|
Created_ |
Date log entry was created (smalldatetime, NULL) |
|
List _ |
Name of list this log entry is for, if applicable (varchar(60), NULL) |
|
LogID_ |
Unique log ID (int, identity, NOT NULL) |
|
OutmailID_ |
ID of the row in outmail_ that generated this log entry. (int, NULL) |
|
RecipientCount_ |
The number of recipients to receive this message. (int, NULL) |
|
Referer_ |
Name of the object this log entry is referring to (varchar(50), NULL) |
|
Site_ |
Name of site this log entry is for, if applicable (varchar(50), NOT NULL) |
|
Source_ |
Source module that is logging this ('ListManager list posting', 'ListManager autoresponder', 'ListManager digest posting', 'ListManager index posting'). (varchar(50), NOT NULL) |
|
SubsetID_ |
The ID of the subset used to create the message this log entries details. NULL or 0 if no subset used. (int, NULL) |
|
Title_ |
English title of this log entry description (refers to documents table) (varchar(200), NULL) |
|
UserName_ |
Person who caused this log (varchar(100), NULL) |
|
|