ms_trashbin Table (312)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
This table contains entries for emails which have been trashed by a filter, waiting for confirmation of deletion or import.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| mail_sorter_id | The id of the filter which sent this email to the trashbin. | FK ms_filter | |
| mail_in_filter_id | The id of the mailbox from which this email came. | FK mail_in_filter | |
| when_trashed | When the email was trashed by the filter. | DateTime | ● |
| subject | The subject field of the trashed email | String(255) | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| 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.