mailio_mail@
Tables (9)
Account
- account_id — INTEGER — Primary key — NOT NULL
- user_id (user_id2) — INTEGER — Foreign key → User.user_id — NOT NULL
- email — TEXT — NOT NULL
- imap_host — TEXT
- imap_port — INTEGER
- smtp_host — TEXT
- smtp_port — INTEGER
- auth_method — TEXT
- provider — TEXT
- created_at — DATETIME
- password — TEXT
Attachment
- attachment_id — INTEGER — Primary key — NOT NULL
- message_id — INTEGER — Foreign key → Message.message_id — NOT NULL
- filename — TEXT
- mime_type — TEXT
- path — TEXT
- size — INTEGER
- created_at — DATETIME — NOT NULL
Category
- category_id — INTEGER — Primary key — NOT NULL
- category_name — INTEGER
EmailContact
- contact_id — INTEGER — Primary key — NOT NULL
- email — TEXT — NOT NULL
- name — TEXT
- created_at — DATETIME
- last_seen_at — DATETIME
Folder
- folder_id — INTEGER — Primary key — NOT NULL
- account_id (account_id2) — INTEGER — Foreign key → Account.account_id — NOT NULL
- name — TEXT — NOT NULL
- path — TEXT
- type — TEXT
- flags — TEXT
- uid_next — INTEGER
- uid_validity — INTEGER
- messages_total — INTEGER
- messages_recent — INTEGER
- messages_unseen — INTEGER
- last_sync_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
Header
- header_id — INTEGER — Primary key — NOT NULL
- message_id — INTEGER — Foreign key → Message.message_id — NOT NULL
- name — TEXT
- value — TEXT
Message
- message_id — INTEGER — Primary key — NOT NULL
- account_id (account_id2) — INTEGER — Foreign key → Account.account_id — NOT NULL
- folder_id (folder_id2) — INTEGER — Foreign key → Folder.folder_id — NOT NULL
- thread_id — TEXT
- external_message_id — TEXT
- from_email — TEXT
- from_name — TEXT
- subject — TEXT
- snippet — TEXT
- body_text — TEXT
- body_html — TEXT
- reply_to — TEXT
- in_reply_to — TEXT
- reference_ids — TEXT
- sent_at — DATETIME
- received_at — DATETIME
- is_read — INTEGER
- is_flagged — INTEGER
- has_attachments — INTEGER
- uid — TEXT
- created_at — DATETIME — NOT NULL
- UNIQUE(account_id, — external_message_id)
- UNIQUE(folder_id, — uid)
- category_id — INTEGER — Foreign key → Category.category_id — NOT NULL
- sub_category_id — INTEGER — Foreign key → Category.category_id — NOT NULL
MessageContact
- message_contact_id — INTEGER — Primary key — NOT NULL
- message_id (message_id2) — INTEGER — Foreign key → Message.message_id — NOT NULL
- contact_id — INTEGER — Foreign key → EmailContact.contact_id — NOT NULL
- type — TEXT — NOT NULL
- created_at — DATETIME
- UNIQUE(message_id, — contact_id,
User
- user_id — INTEGER — Primary key — NOT NULL
- username — TEXT — NOT NULL
- created_at — DATETIME