Contains an entry for each email address referenced by messages in the database. The email addresses are extracted from the header fields: To, Cc, From, Reply-To. The table is updated each time a new message is added to the database. It is also possible to add manually new addresses and comments, like in an address book.
Structure of addresses
addr_idinteger
Unique internal identifier for the email address.
email_addrtext
The email address, in lowercase characters. It is unique.
nametext
The name (or rfc822 comment) that is optionally associated to the email.
nicknametext
An optional short alias for the email address.
last_sent_totimestamp with time zone
The most recent date at which a mail has been sent by manitou to this address.
last_recv_fromtimestamp with time zone
The most recent date at which a mail sent by this address has been received by manitou.
notestext
Optional comments on the contact.
invalidinteger
A flag indicating that this address is invalid and shouldn't be used for future messages. Such addresses are to be kept in the table only if messages still reference them.
recv_priinteger
The priority of the contact. When a message comes from this email address (according to the From field), this value is added to priority of the message. It can be negative.
nb_sent_tointeger
The total number of messages sent to this address.
nb_recv_frominteger
The total number of messages having this address as a recipient.
Tables referencing addresses via Foreign Key Constraints