개발 erd

테이블 (6)

category

  • category_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL

lesson

  • lesson_id — BIGINT — 기본 키 — NOT NULL
  • topic_id — BIGINT — 외래 키 → topic.topic_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • lesson_order — INT — NOT NULL

quiz_attempt

  • attempt_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • quiz_id — BIGINT — 외래 키 → quiz_item.quiz_id — NOT NULL
  • response — JSON
  • is_correct — BOOLEAN
  • time_spent_ms — INT
  • attempted_at — DATETIME

quiz_item

  • quiz_id — BIGINT — 기본 키 — NOT NULL
  • lesson_id — BIGINT — 외래 키 → lesson.lesson_id — NOT NULL
  • question — TEXT — NOT NULL
  • instruction — VARCHAR(500)
  • interaction_type — VARCHAR(30) — NOT NULL
  • config — JSON
  • answer — JSON
  • explanation — TEXT
  • difficulty — INT
  • quiz_order — INT — NOT NULL

topic

  • topic_id — BIGINT — 기본 키 — NOT NULL
  • category_id — BIGINT — 외래 키 → category.category_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL

users

  • user_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100)
  • password — VARCHAR(255) — NOT NULL