d

Tables (5)

chat

  • chat_id — INT — Primary key — NOT NULL
  • chatroom_id — CHAR(36) — Foreign key → chatroom.chatroom_id — NOT NULL
  • speaker — ENUM('user','llm') — NOT NULL
  • message — TEXT — NOT NULL
  • topic — VARCHAR(100)
  • created_at — DATETIME — NOT NULL

chatroom

  • chatroom_id — CHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(20) — Foreign key → user.user_id — NOT NULL
  • chatroom_name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • deleted_at — DATETIME

document

  • doc_id — INT — Primary key — NOT NULL
  • original_file_name — VARCHAR(255) — NOT NULL
  • stored_file_name — VARCHAR(255) — NOT NULL
  • file_path — VARCHAR(500) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • is_loaded — BOOLEAN — NOT NULL
  • loaded_at — DATETIME
  • is_deleted — BOOLEAN — NOT NULL
  • deleted_at — DATETIME

user

  • user_id — VARCHAR(20) — Primary key — NOT NULL
  • passwd — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • department — VARCHAR(100) — NOT NULL
  • is_admin — BOOLEAN — NOT NULL
  • is_disabled — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

user_login_history

  • history_id — INT — Primary key — NOT NULL
  • user_id — VARCHAR(20) — Foreign key → user.user_id — NOT NULL
  • created_at — DATETIME — NOT NULL