jack
Tables (6)
chapter
- id — INT
- course_id — INT — NOT NULL
- owner_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- order_index — INT
- is_active — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
concept
- id — INT
- chapter_id — INT — NOT NULL
- owner_id — INT — 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
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- difficulty — ENUM('easy','medium','hard')
- owner_id — INT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
exercise
- id — INT
- chapter_id — INT — NOT NULL
- owner_id — INT — 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
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- role — ENUM('student','admin')
- created_at — DATETIME
- updated_at — DATETIME
quiz
- id — INT
- chapter_id — INT — NOT NULL
- owner_id — INT — 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