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