성큼성큼
테이블 (9)
chat_answer
- message_id — bigint — 외래 키 → chat_message.id — NOT NULL
- created_at — datetime — NOT NULL
chat_message
- id — bigint — 기본 키 — NOT NULL
- session_id — bigint — 외래 키 → chat_session.id — NOT NULL
- role — enum('USER','ASSISTANT','SYSTEM') — NOT NULL
- content — mediumtext — NOT NULL
- created_at — datetime — NOT NULL
chat_session
- id — bigint — 기본 키 — NOT NULL
- user_email — varchar(255) — 외래 키 → user.email — NOT NULL
- title — varchar(200)
- started_at — datetime — NOT NULL
- last_activity_at — datetime — NOT NULL
quiz_attempt
- id — bigint — 기본 키 — NOT NULL
- scenario_id — bigint — 외래 키 → quiz_scenario.id — NOT NULL
- user_email — varchar(255) — 외래 키 → user.email — NOT NULL
- started_at — datetime — NOT NULL
- submitted_at — datetime
- score_total — int
- score_max — int
- status — enum('IN_PROGRESS','SUBMITTED','CANCELLED')
quiz_option
- id — bigint — 기본 키 — NOT NULL
- question_id — bigint — 외래 키 → quiz_question.id — NOT NULL
- label — varchar(5) — NOT NULL
- text — text — NOT NULL
- is_correct — tinyint(1) — NOT NULL
quiz_question
- id — bigint — 기본 키 — NOT NULL
- scenario_id — bigint — 외래 키 → quiz_scenario.id — NOT NULL
- stem — text — NOT NULL
- correct_text — text
quiz_response
- attempt_id — bigint — 외래 키 → quiz_attempt.id — NOT NULL
- question_id — bigint — 외래 키 → quiz_question.id — NOT NULL
- option_id — bigint — 외래 키 → quiz_option.id
- text_answer — text
- is_correct — tinyint(1)
- score — int
- created_at — datetime — NOT NULL
quiz_scenario
- id — bigint — 기본 키 — NOT NULL
- title — varchar(200) — NOT NULL
user
- email — varchar(255) — 기본 키 — NOT NULL
- password_hash — varchar(255) — NOT NULL
- nickname — varchar(50) — NOT NULL
- gender — enum('F','M')
- birthyear — int — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- status — enum('ACTIVE','SUSPENDED','DELETED')