• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

mail_in_filter Table (271)

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

mail_in_filter table relationship diagram

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.

Replication Flags

  • None

Security Flags

  • No access control via user's Role.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top