quiz
Tables (6)
Answer (퀴즈 응답)
- id (pk) — auto_increment — Primary key — NOT NULL
- participant_id (fk) — Foreign key → Participants.id — NOT NULL
- question_id (fk2) — Foreign key → Questions.id — NOT NULL
- choice_Id (fk3) — Foreign key → choice.id — NOT NULL
- content (Field) — nullable
- IsCorrect (Field2) — 0-false, 1-true
- score (Field3)
- created_at (Field4)
- updated_at (Field5)
- deleted_at (Field6)
Participants (참여자)
- id (pk) — auto_increment — Primary key — NOT NULL
- quiz_id (fk) — Foreign key → Quiz.id — NOT NULL
- nickname (Field)
Questions (퀴즈 질문 정보)
- id (pk) — auto_increment — Primary key — NOT NULL
- quiz_id (fk) — Foreign key → Quiz.id — NOT NULL
- content (Field)
- score (Field2)
- created_at (Field3)
- updated_at (Field4)
- deleted_at (Field5)
Quiz (퀴즈정보)
- id (pk) — auto_increment — Primary key — NOT NULL
- user_id (fk) — Foreign key → User.id — NOT NULL
- title (Field)
- type (Field2)
- pin (Field3)
- created_at (Field4)
- updated_at (Field6)
- deleted_at (Field5)
User (회원)
- id (pk) — auto_increment — Primary key — NOT NULL
- email (Field)
- password (Field2)
- nickname (Field3)
- created_at (Field4)
- updated_at (Field5)
- deleted_at (Field6)
choice (퀴즈 선택)
- id (pk) — auto_increment — Primary key — NOT NULL
- question_id (fk) — Foreign key → Questions.id — NOT NULL
- content (Field)
- IsCorrect (Field2) — 0-false, 1-true
- created_at (Field3)
- updated_at (Field4)
- deleted_at (Field5)