db

Tables (3)

question (문제)

  • id (pk) — int — Primary key — NOT NULL
  • phrase (Field) — varchar(100)
  • one (Field2)
  • two (Field3)
  • three (Field4)
  • four (Field5)
  • answer (Field6)
  • who (Field7)

result (결과)

  • id (pk) — int — Primary key — NOT NULL
  • choice (Field3) — int
  • correct (Field4) — boolean
  • code (Field1) — int — Foreign key → user.id — NOT NULL
  • question (Field2) — int — Foreign key → question.id — NOT NULL

user (사용자)

  • id (pk) — int — Primary key — NOT NULL
  • name (Field) — varchar(45)
  • birth (Field2) — varchar(45)
  • code (Field3) — varchar(45)