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_addrcharacter varying(300)
The email address, in lowercase characters. It is unique.
namecharacter varying(300)
The name (or rfc822 comment) that is optionally associated to the email.
nicknamecharacter varying(300)
An optional nickname for the contact. Can be used as an 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 about 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.
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 mail_addresses via Foreign Key Constraints