poke

Tables (3)

Quiz

  • id — Long — Primary key — NOT NULL
  • question — String
  • correctAnswer — String
  • options — List

User

  • id — Long — Primary key — NOT NULL
  • username — String — 사용자 이름
  • password — String
  • points — int

UserQuizHistroy (UserQuizHistory)

  • id — Long — Primary key — NOT NULL
  • user_id — Long — Foreign key → User.id — NOT NULL
  • quiz_id — Long — Foreign key → Quiz.id — NOT NULL
  • isCorrect — boolean
  • solvedAt — DateTime
  • id (id2) — Long — Foreign key → User.id — NOT NULL