Differences

This shows you the differences between two versions of the page.

--- reference:logdb_attachments [2011/08/31 10:19] – created paul
+++ reference:logdb_attachments [2011/08/31 10:23] – paul
@@ Line 1: / Line 1: @@
-======LogDB.Recipients table======
+======LogDB.Attachments table======
-The [[LogDB]].Recipients table contains a record of the recipients for messages logged by VPOP3. A message may have one or more recipients
+The [[LogDB]].Attachments table contains a record of the attachments for messages logged by VPOP3. A message may have zero or more attachments
 =====Columns=====
-  * rcptid -  this is a [[http://www.postgresql.org/docs/9.0/static/datatype-numeric.html|bigint]] sequential value which identifies the recipient uniquely in the database
+  * attachid -  this is a [[http://www.postgresql.org/docs/9.0/static/datatype-numeric.html|bigint]] sequential value which identifies the attachment uniquely in the database
   * msgid - this is a bigint value linking this message to a [[logdb messages|message]]
-  * name - the recipient email address
+  * filename - the attachment file name
-  * rcpttype - the type of recipient (see below)
+  * size - the attachment size (in bytes)
-  * result - text containing the result of this recipient (eg when sending the message)
+  * comments - text containing the notes about the attachment (if any - eg 'Filtered' if attachment filtering took place)
+  * virusinfo - text containing details of any detected viruses in the attachment
-Note that recipients are NOT 'normalised'. If you send two messages to the same recipient, there will be two entries in the 'recipients' table, not just one.
-====RcptType values====
-  * F = LAN forwarded (on incoming messages)
-  * I = invalid (on incoming messages)
-  * N = normal (on incoming messages)
-  * R = remote (on incoming messages)
-  * S = being sent (on outgoing messages)

PSCS Wiki

User Tools

Site Tools

Differences

Page Tools