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