Squiz
Tables (6)
bookmark (relation entity2)
- bookmark_id (Key) — INT(10) — Primary key — NOT NULL
- user_id (Key2) — INT(10) — Foreign key → user.user_id — NOT NULL
- quiz_id (Key3) — INT(10) — Foreign key → quiz.quiz_id — NOT NULL
category (ENUM)
- AGRI (Field)
- LEGL (Field2)
- ARCH (Field3)
- MECH (Field4)
- BIO_ (Field5)
- MEDI (Field6)
- BUSI (Field7)
- PHYS (Field8)
- COMP (Field9)
- PSYC (Field10)
- CULI (Field11)
- SCHL (Field12)
- ENGR (Field13)
- ARTS (Field14)
- HLTH (Field15)
- TRAN (Field16)
- HUMN (Field17)
- MISC (Field18)
quiz (entity2)
- quiz_id (Key) — INT(10) — Primary key — NOT NULL
- user_id (Key3) — INT(10) — Foreign key → user.user_id — NOT NULL
- category (Field12) — VARCHAR(255)
- title (Field10) — VARCHAR(255)
- email (Field) — VARCHAR(255)
- nickname (Field2) — VARCHAR(255)
- result_count (Field3) — INT(10)
- correct_count (Field4) — INT(10)
- correct_rate (Field5) — FLOAT(3,2)
- status (Field6) — VARCHAR(255)
- likes (Field7) — INT(10)
quiz_question (entity3)
- question_id (Key) — INT(10) — Primary key — NOT NULL
- quiz_id (Key2) — INT(10) — Foreign key → quiz.quiz_id — NOT NULL
- question_number (Field) — INT(10)
- question (Field2) — VARCHAR(10)
- option1 (Field3) — VARCHAR(10)
- option2 (Field4) — VARCHAR(10)
- option3 (Field5) — VARCHAR(10)
- option4 (Field6) — VARCHAR(10)
- correct_answer (Field7) — VARCHAR(10)
quiz_result (relation entity)
- result_id (Key) — INT(10) — Primary key — NOT NULL
- user_id (Key2) — INT(10) — Foreign key → user.user_id — NOT NULL
- quiz_id (Key22) — INT(10) — Foreign key → quiz_question.quiz_id — NOT NULL
- question_id (Key3) — INT(10) — Foreign key → quiz_question.question_id — NOT NULL
- user_answer (Field4) — VARCHAR(10)
- is_correct (Field2) — BOOLEAN
- timestamp (Field3) — DATETIME
user (entity)
- user_id (Key) — INT(10) — Primary key — NOT NULL
- password (Field3) — VARCHAR(255)
- email (Field2) — VARCHAR(255)
- nickname (Field) — VARCHAR(255)
- gender (Field5) — VARCHAR(255)
- is_deleted (Field6) — BOOLEAN
- role (Field7) — VARCHAR(255)
- verify_code (Field4) — INT(10)