weekthon

Tables (4)

category (카테고리)

  • category_id (Key) — bigint — Primary key — NOT NULL
  • name (카테고리명) — varchar(255)
  • created_at (생성일) — datetime
  • updated_at (수정일) — datetime

quiz (퀴즈)

  • quiz_id (Key) — bigint — Primary key — NOT NULL
  • question (질문) — varchar(255)
  • quiz_type (퀴즈 유형) — enum
  • created_at (생성일) — datetime
  • updated_at (수정일) — datetime
  • category_id (Key2) — bigint — Foreign key → category.category_id — NOT NULL

quiz_log (퀴즈 풀이 기록)

  • quiz_log_id (Key) — bigint — Primary key — NOT NULL
  • is_correct (정답 여부) — bit
  • quiz_id (Key2) — bigint — Foreign key → quiz.quiz_id — NOT NULL

quiz_option (퀴즈 선택지)

  • option_id (Key) — bigint — Primary key — NOT NULL
  • content (선택지 내용) — varchar(255)
  • description (선택지 설명) — text
  • is_answer (정답 선택지 여부) — bit
  • created_at (생성일) — datetime
  • updated_at (수정일) — datetime
  • quiz_id (Key2) — bigint — Foreign key → quiz.quiz_id — NOT NULL