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