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)