User Tools

Site Tools


reference:logdb_attachments

Differences

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

Link to this comparison view

Next revision
Previous revision
reference:logdb_attachments [2011/08/31 10:19]
paul created
reference:logdb_attachments [2018/11/14 10:45] (current)
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===== =====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]]   * 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) 
  
reference/logdb_attachments.txt · Last modified: 2018/11/14 10:45 (external edit)