User Tools

Site Tools


reference:logdb_recipients

Differences

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

Link to this comparison view

reference:logdb_recipients [2018/11/14 10:45] (current)
Line 1: Line 1:
 +======LogDB.Recipients table======
 +The [[LogDB]].Recipients table contains a record of the recipients for messages logged by VPOP3. A message may have one or more recipients
 +
 +=====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
 +  * msgid - this is a bigint value linking this message to a [[logdb messages|message]]
 +  * name - the recipient email address
 +  * rcpttype - the type of recipient (see below)
 +  * result - text containing the result of this recipient (eg when sending the message)
 +
 +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_recipients.txt ยท Last modified: 2018/11/14 10:45 (external edit)