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_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_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_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)
user_search
- search_no — integer
- search_name — text
- search_content — text