Structure of mail_addresses

mail_id

integer

Unique internal identifier of the message.

REFERENCES mail

addr_id

integer

Unique internal identified of a recipient.

REFERENCES addresses

addr_type

smallint

A constant integer that identifies the header where the email address is referenced. The possible values are:

• From: 1

• To: 2

• Cc: 3

• ReplyTo: 4

• Bcc (only for outgoing messages): 5

addr_pos

smallint

The position of the address (starting from 0) in the header when it contains a list of addresses.