Structure of mail_tags

Contains the mapping between the mail messages and the tags assigned to them.

mail_id

integer

Unique internal identifier of the message.

REFERENCES mail

tag

integer

Unique internal identifier of a tag.

REFERENCES tags

agent

integer

Unique internal identifier of the operator or agent that assigned the tag to the mail. Generally NULL if the tag was automatically assigned by a filter rule or another automatic way. In the latter case, specific pseudo-users can also be set up as tagging agents if needed.

date_insert

timestamp with time zone DEFAULT now()

Date and time of the insertion.