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