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