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)