ㅁㅁ

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