MZQuiz

Tables (4)

QUIZ (문항)

  • Q_IDX (Key) — NUMBER — Primary key — NOT NULL
  • TITLE (Field) — VARCHAR
  • POINT (점수) — NUMBER
  • ISMULTIPLE (객관식 유/무) — BOOLEAN
  • COUNT (Field2) — NUMBER
  • QH_IDX (QUIZ_HEADER KEY) — NUMBER — Foreign key → QUIZ_HEADER.QH_IDX — NOT NULL

QUIZ_HEADER (그룹)

  • QH_IDX (Key) — NUMBER — Primary key — NOT NULL
  • TITLE (제목) — VARCHAR
  • CONTENT (내용) — VARCHAR

QUIZ_IMG (Untitled)

  • QI_IDX (Key) — NUMBER — Primary key — NOT NULL
  • PATH (경로) — VARCHAR
  • Q_IDX (QUIZ KEY) — NUMBER — Foreign key → QUIZ.Q_IDX — NOT NULL

QUIZ_SELECTION (답)

  • QS_IDX (KEY) — NUMBER — Primary key — NOT NULL
  • CONTENT (내용) — VARCHAR
  • ISANSWER (정답 유/무) — BOOLEAN
  • Q_IDX (QUIZ Key) — NUMBER — Foreign key → QUIZ.Q_IDX — NOT NULL