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.

> Columns

• addr_id: integer, primary key
  Unique internal identifier for the email address.

• email_addr: varchar(300), unique
  The email address, in lowercase characters. It is unique.

• name: varchar(300)
  The name (or rfc822 comment) that is optionally associated to the email.

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

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

• nb_messages: integer
  The total number of messages in which this address appears in a From, To, Cc or Reply-To header. Currently not set

• notes: text
  Optional comments about the contact.

• nickname: varchar(300)
  An optional nickname for the contact. Can be used as an alias for the email address.

• 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.

• 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.

> Size

One row per contact.