List of tables

• addresses Email addresses of all recipients and senders for the whole mail corpus.
• attachment_contents Large objects containing decoded and transparently compressed attachment contents.
• attachments Attachments characteristics of all messages.
• auto_action (Obsolete).
• body Decoded bodies of all messages.
• config Configuration entries containing users setups.
• files References to mailfiles.
• filter_action Actions carried out by the filtering system when rules match.
• filter_expr Expressions evaluated by the filtering system.
• filter_log Logs of filter hits
• identities Sender accounts.
• inverted_word_index Index for full text search
• header Unfolded and decoded headers for all messages.
• mail The main table with one entry per incoming and outgoing message.
• mailboxes Recipient accounts.
• mail_addresses All recipients and senders for each message.
• mail_tags Hierarchical categorization with multiple entries per mail.
• mail_status Identifies where a not yet processed mail is in the workflow.
• notes Private notes on messages.
• programs Helper programs for viewing attachments.
• runtime_info Entries used for monitoring the activity.
• non_indexable_words Stopwords for full text search
• tags Definition of the categories
• trashed_mail Trashed messages. (obsolete)
• users User accounts.
• words List of words for full text search