개발 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