onboarding

Tables (5)

answer_item (응답 항목)

  • seq_answ_item — Primary key — NOT NULL
  • seq_answer_root (Key) — Foreign key → answer_root.seq_answer_root — NOT NULL
  • seq_item — Foreign key → survey_item.seq_item — NOT NULL
  • seq_option — Foreign key → item_option.seq_option — NOT NULL
  • txtVal (응답 값)

answer_root (Untitled)

  • seq_answer_root (Key) — Primary key — NOT NULL
  • seq_survey — Foreign key → survey.seq_survey — NOT NULL

item_option (항목 보기)

  • seq_option — Primary key — NOT NULL
  • value
  • seq_item — Foreign key → survey_item.seq_item — NOT NULL

survey (설문조사)

  • seq_survey — Primary key — NOT NULL
  • 제목 (title)
  • 설명 (desc)

survey_item (설문조사 항목)

  • seq_item — Primary key — NOT NULL
  • seq_survey — Foreign key → survey.seq_survey — NOT NULL
  • 제목 (title)
  • 설명 (desc)
  • 필수 (is_required)
  • 타입 (type)