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