성큼성큼

테이블 (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')