mail_sqlite

Tables (21)

go_companies

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • user_count — INTEGER
  • site_url — VARCHAR(255)
  • uuid — VARCHAR(255)

go_users

  • id — BIGINT — Primary key — NOT NULL
  • login_id — VARCHAR(255)
  • mail_group — VARCHAR(255)
  • name — VARCHAR(255) — NOT NULL
  • company_id (id2) — BIGINT — Foreign key → go_companies.id — NOT NULL
  • mail_user_seq — BIGINT — Foreign key → mail_user.mail_user_seq — NOT NULL

mail_attach_content

  • docid — INTEGER

mail_attach_segdir

  • level — INTEGER
  • idx — INTEGER
  • start_block — INTEGER
  • leaves_end_block — INTEGER
  • end_block — INTEGER
  • root — BLOB

mail_attach_segments

  • blockid — INTEGER
  • block — BLOB

mail_body_content

  • docid — INTEGER

mail_body_segdir

  • level — INTEGER
  • idx — INTEGER
  • start_block — INTEGER
  • leaves_end_block — INTEGER
  • end_block — INTEGER
  • root — BLOB

mail_body_segments

  • blockid — INTEGER
  • block — BLOB

mail_body_test_content

  • docid — INTEGER

mail_body_test_segdir

  • level — INTEGER
  • idx — INTEGER
  • start_block — INTEGER
  • leaves_end_block — INTEGER
  • end_block — INTEGER
  • root — BLOB

mail_body_test_segments

  • blockid — INTEGER
  • block — BLOB

mail_folder

  • folder_no — integer
  • folder_name — text
  • version_no — integer
  • uid_validity — integer
  • uid_next — integer
  • msg_count — integer
  • recent_count — integer
  • unseen_count — integer
  • disk_usage — integer
  • modify_time — integer

mail_header

  • folder_no — integer
  • uid_no — integer
  • header_content — text

mail_message

  • folder_no — integer
  • uid_no — integer
  • host_name — text
  • full_path — text
  • env_from — text
  • msg_flag — integer
  • msg_size — integer
  • msg_receive — integer
  • msg_date — text
  • msg_subject — text
  • msg_from — text
  • msg_sender — text
  • msg_reply — text
  • msg_to — text
  • msg_cc — text
  • msg_bcc — text
  • msg_inreplyto — text
  • msg_id — text
  • msg_priority — text
  • msg_bodystructure — text
  • msg_preview — text
  • msg_reference — text
  • msg_integrity — text

mail_message_attach

  • messag_rowid — integer
  • attach_rowid — integer
  • attach_name — text

mail_search

  • folder_no — integer
  • uid_no — integer
  • msg_subject — text
  • msg_from — text
  • msg_to — text
  • msg_cc — text
  • msg_received_day — integer
  • msg_sent — integer
  • msg_sent_day — integer
  • attach_name — text
  • attach_count — integer
  • attach_size — integer

mail_tag

  • tag_no — integer
  • tag_name — text
  • tag_color — text

mail_tag_message

  • tag_no — integer
  • folder_no — integer
  • uid_no — integer

mail_user

  • mail_user_seq — BIGINT — Primary key — NOT NULL
  • mail_uid — VARCHAR(128) — NOT NULL
  • message_store — VARCHAR(255)

table_check

  • check_no — integer

user_search

  • search_no — integer
  • search_name — text
  • search_content — text