mail_in_filter Table (271)
•
Environment: onsite, online
Some tooltip text!
• 5 minutes to read
• 5 minutes to read
This table contains entries for the mailboxes the eJournal system is fetching mail from (POP3 or IMAP).
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| server_type | Enum indicating the protocol to use (POP/IMAP). | Enum MailboxType | ● |
| pop_server | The hostname/IP address of the server. | String(255) | ● |
| pop_user | The username used to login. | String(255) | ● |
| pop_password | The password used to login. | String(255) | ● |
| domain | The domain used to login. | String(255) | ● |
| address | The address associated with this mailbox (used as FROM: address when sending emails). | String(255) | ● |
| category_id | The id of the category this mailbox assigns tickets to (unless overridden by a sortfilter). | FK ej_category | ● |
| priority | The id of the priority tickets are assigned when imported from this mailbox. | FK ticket_priority | ● |
| reply_template_id | ID of the reply template used on this mail box. | FK reply_template | |
| checkwait | How often (in minutes) to check this mailbox. | Int | |
| next_check | When this mailbox should be checked the next time. | DateTime | ● |
| noautoreply | If set, then this mailbox should not send an autoreply. | Bool | ● |
| last_success | Datetime indicating the last time email was sucessfully imported from this mailbox. Used to display warnings when this value is getting too old. | DateTime | ● |
| last_try | Datetime indicating the last time this mailbox tried (but possibly failed) to fetch email. | DateTime | ● |
| importmail_pid | The process id of the importMail instance processing this mailbox | Int | ● |
| status | Status indicated whether this mailbox is deleted or not. | status | ● |
| last_error | The last error message recieved from the underlying email system (such as POP3 protocol errors, etc). | Clob | ● |
| num_seq_failures | The number of sequential failures for this mailbox. | Int | ● |
| keep_headers | A commaseparated list of headers to store for emails imported. E.g. 'to,from,recieved-by,subject'. | String(255) | ● |
| language_id | The id of the customer language entry this entry is connected to. | FK cust_lang | ● |
| autofaq | Whether to suggest FAQ entries for this email account or not | Bool | ● |
| autofaq_kb_category | The root folder for the auto faq search. | FK kb_category | ● |
| mailgun_dsn | If this is set to 1, the route created in Mailgun will be set up to deliver emails of type auto-replies, system messsages etc | Bool | ● |
| ai_suggest_category | If this is set to 0 (false), then there will be no AI for suggesting categories on incoming emails | Bool | |
| ai_text_analysis | If this is set to 0 (false), then there will be no AI text analysis on incoming emails | Bool | |
| ticket_type | Tickettype of the ticket | FK ticket_type | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| category_id | FK | Index |
| priority | FK | Index |
| reply_template_id | FK | Index |
| language_id | FK | Index |
Relationships
| Table | Description |
|---|---|
| cust_lang | This table contains entries for customer languages. |
| ej_category | This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner. |
| inbox | Info and status for safe email import |
| kb_category | Knowledge base folder hierarchy |
| mail_alias | This table contains the alias'es for each mailbox, one-to-many-relation. It is in so we can substract the alias'es when when listing the recipients of a message. |
| mail_in_uidl | This table is used to avoid spamming the system by importing the same message several times (normally a result of a crash somewhere). When a mailbox is openede, then unique id for each message is stored in this table, and then removed only when the message has been correctly imported and deleted from mailbox. |
| ms_filter_mail | This table connects mail filters (ms_filter) to mailboxes (mail_in_filter). |
| ms_trashbin | This table contains entries for emails which have been trashed by a filter, waiting for confirmation of deletion or import. |
| reply_template | Templates for automatic and manual replies to emails/sms organized hierachically |
| ticket | This table contains the tickets (requests) of the system. Its purpose should be evident. |
| ticket_priority | This table contains the ticket priorities. |
| ticket_type | A ticket (request) type |
Replication Flags
- None
Security Flags
- No access control via user's Role.