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