123

Tables (3)

QUIZS

  • PK_QUIZ_ID — VARCHAR(50) — Primary key — NOT NULL
  • QUESTIONS — VARCHAR(255)
  • ANSWERS — VARCHAR(255)
  • POINTS — DECIMAL(20,0)
  • CORRECT — VARCHAR(10)
  • NUMBERS — DECIMAL(20,0)
  • FK_QUIZ_ID — VARCHAR(50) — Foreign key → QUIZS.PK_QUIZ_ID — NOT NULL

RESPOND

  • RESPOND_ID — VARCHAR(50) — Primary key — NOT NULL
  • USER_ID — VARCHAR(50) — Foreign key → USER.USER_ID — NOT NULL
  • QUIZ_ID — VARCHAR(50) — Foreign key → QUIZS.PK_QUIZ_ID — NOT NULL

USER

  • USER_ID — VARCHAR(50) — Primary key — NOT NULL
  • USER — VARCHAR(100)