mars
Tables (8)
alembic_version
- version_num — varchar(32) — Primary key — NOT NULL
attachments
- attachment_id — char(32) — Primary key — NOT NULL
- message_id — char(32) — Foreign key → messages.message_id — NOT NULL
- name — varchar(500) — NOT NULL
- content_type — varchar(100) — NOT NULL
- size — int — NOT NULL
- data — longblob — NOT NULL
- created_at — datetime(6) — NOT NULL
documents
- document_id — char(32) — Primary key — NOT NULL
- project_id — char(32) — Foreign key → projects.project_id
- user_id — char(32) — Foreign key → users.user_id
- name — varchar(500) — NOT NULL
- domain — varchar(50) — NOT NULL
- department — varchar(100)
- visibility — enum('ALL','DEPT_ONLY') — NOT NULL
- content_type — varchar(100) — NOT NULL
- size — int — NOT NULL
- data — longblob — NOT NULL
- status — varchar(20) — NOT NULL
- job_id — varchar(64)
- chunks_indexed — int
- error — text
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
messages
- message_id — char(32) — Primary key — NOT NULL
- session_id — char(32) — Foreign key → sessions.session_id — NOT NULL
- role — enum('human','ai') — NOT NULL
- domain — varchar(50)
- content — mediumtext — NOT NULL
- created_at — datetime(6) — NOT NULL
- notice_code — varchar(50)
projects
- project_id — char(32) — Primary key — NOT NULL
- user_id — char(32) — Foreign key → users.user_id — NOT NULL
- title — varchar(255) — NOT NULL
- is_favorite — tinyint(1) — NOT NULL
- instructions — text
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
sessions
- session_id — char(32) — Primary key — NOT NULL
- user_id — char(32) — Foreign key → users.user_id — NOT NULL
- title — varchar(255) — NOT NULL
- is_favorite — tinyint(1) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- project_id — char(32) — Foreign key → projects.project_id
sources
- source_id — char(32) — Primary key — NOT NULL
- message_id — char(32) — Foreign key → messages.message_id — NOT NULL
- name — varchar(500) — NOT NULL
- page — varchar(50)
- created_at — datetime(6) — NOT NULL
users
- user_id — char(32) — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- role — enum('user','admin') — NOT NULL
- status — enum('pending','approved','rejected') — NOT NULL
- refresh_token — varchar(512)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL