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