manualLLM
Tables (3)
chat_history
- id — BIGINT — Primary key — NOT NULL
- user_id — NVARCHAR(50) — Foreign key → user.user_id — NOT NULL
- question — NVARCHAR(MAX) — NOT NULL
- answer — NVARCHAR(MAX) — NOT NULL
- category — NVARCHAR(50)
- created_at — DATETIME — NOT NULL
semantic_cache
- id — BIGINT — Primary key — NOT NULL
- user_id — NVARCHAR(50) — Foreign key → user.user_id
- question_hash — NVARCHAR(64) — NOT NULL
- question_embedding — VARBINARY(MAX) — NOT NULL
- answer — NVARCHAR(MAX) — NOT NULL
- category — NVARCHAR(50)
- hit_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- last_accessed_at — DATETIME — NOT NULL
user
- id — BIGINT — Primary key — NOT NULL
- user_id — NVARCHAR(50) — NOT NULL
- password — NVARCHAR(255) — NOT NULL
- role — NVARCHAR(20) — NOT NULL