maumlab
Tables (5)
answer (답변)
- ID (answerId) — int — Primary key — NOT NULL
- optionId (Key2) — int — Foreign key → options.ID — NOT NULL
- answer (답변 내용) — string
- point (답변의 점수) — enum
completed (설문지 확인)
- ID (Key) — int — Primary key — NOT NULL
- questionnaireId (Key2) — int — Foreign key → questionnaire.ID — NOT NULL
- quetion (option, answer, point) — array
- total (총 점수) — int
options (선택지)
- ID (optionId) — int — Primary key — NOT NULL
- quetionId (Key2) — int — Foreign key → question.ID — NOT NULL
- options (선택지 내용) — string
question (문항)
- ID (quetionId) — int — Primary key
- questionnaireId (Key2) — int — Foreign key → questionnaire.ID — NOT NULL
- desc (문항 내용) — string — NOT NULL
questionnaire (설문지)
- ID (questionnaireId) — int — Primary key — NOT NULL
- desc (설문지 내용) — string