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.

Related topics

ms_filter table ms_substitute table ms_filter_mail table mail_in_filter table config table Tags table

⌘I