chatbot

Tables (3)

chat_logs

  • id — INT — Primary key — NOT NULL
  • matched_faq_id — INT — Foreign key → faq.id — NOT NULL
  • user_uuid — VARCHAR(50) — NOT NULL
  • message — TEXT — NOT NULL
  • response — TEXT — NOT NULL
  • created_at — TIMESTAMP

faq

  • id — INT — Primary key — NOT NULL
  • parent_id — INT — -- 상위 질문 ID (NULL이면 최상위 메뉴)
  • category — VARCHAR(50) — NOT NULL
  • question — TEXT — NOT NULL
  • answer — TEXT
  • created_at — TIMESTAMP
  • level — INT

search_logs

  • id — INT
  • user_uuid — VARCHAR(50) — NOT NULL
  • query — TEXT — NOT NULL
  • search_result — TEXT — NOT NULL
  • created_at — TIMESTAMP