ㅁㅁ
Tables (6)
chapter
- id — INT — Primary key — NOT NULL
- course_id — INT — Foreign key → course.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- order_index — INT
- is_active — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
concept
- id — INT — Primary key — NOT NULL
- chapter_id — INT — Foreign key → chapter.course_id — NOT NULL
- owner_id — INT — Foreign key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- example — TEXT
- is_complete — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
course
- id — INT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- objective — TEXT
- difficulty — ENUM('easy','medium','hard')
- created_at — DATETIME
- updated_at — DATETIME
exercise
- id — INT — Primary key — NOT NULL
- chapter_id — INT — Foreign key → chapter.course_id — NOT NULL
- owner_id — INT — Foreign key — NOT NULL
- question — TEXT — NOT NULL
- answer — TEXT — NOT NULL
- explanation — TEXT
- difficulty — ENUM('easy','medium','hard')
- is_complete — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
member
- id — INT — Primary key — NOT NULL
- 이메일 (eamil) — VARCHAR(255) — NOT NULL
- 비밀번호 (password) — VARCHAR(255) — NOT NULL
- 생성시간 (created_at) — DATETIME
- 업데이트 시간 (updated_at) — DATETIME
quiz
- id — INT — Primary key — NOT NULL
- chapter_id — INT — Foreign key → chapter.course_id — NOT NULL
- owner_id — INT — Foreign key — NOT NULL
- question — TEXT — NOT NULL
- options — JSON
- correct_answer — VARCHAR(255) — NOT NULL
- explanation — TEXT
- type — ENUM('multiple','short','boolean')
- created_at — DATETIME
- updated_at — DATETIME