Manitou-Mail Home

1.  Table: addresses

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_id

integer

Unique internal identifier for the email address.

email_addr

text

The email address, in lowercase characters. It is unique.

name

text

The name (or rfc822 comment) that is optionally associated to the email.

nickname

text

An optional short alias for the email address.

last_sent_to

timestamp with time zone

The most recent date at which a mail has been sent by manitou to this address.

last_recv_from

timestamp with time zone

The most recent date at which a mail sent by this address has been received by manitou.

notes

text

Optional comments on the contact.

invalid

integer

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_pri

integer

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_to

integer

The total number of messages sent to this address.

nb_recv_from

integer

The total number of messages having this address as a recipient.

Tables referencing mail_addresses via Foreign Key Constraints