ms_trashbin table - SuperOffice

ms_trashbin Table (312)

This table contains entries for emails which have been trashed by a filter, waiting for confirmation of deletion or import.

Fields

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
mail_sorter_id	The id of the filter which sent this email to the trashbin.	FK ms_filter	No
mail_in_filter_id	The id of the mailbox from which this email came.	FK mail_in_filter	No
when_trashed	When the email was trashed by the filter.	DateTime	Yes
subject	The subject field of the trashed email	String(255)	Yes

Indexes

Fields	Types	Description
mail_sorter_id	FK	Index
mail_in_filter_id	FK	Index

Relationships

Table	Description
mail_in_filter	This table contains entries for the mailboxes the eJournal system is fetching mail from (POP3 or IMAP).
ms_filter	This table contains email filters. These are the filters allowing you to do advanced parsing of incomming emails.

Replication Flags

None

Security Flags

No access control via user’s Role.