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)