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