steamApp

Tables (9)

Question (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • question_number (Field) — NOT NULL — 문항번호
  • question_text (Field2) — NOT NULL — 문항내용
  • question_type (Field3) — Enum — NOT NULL
  • survey_page_id (Key2) — Long — Foreign key → SurveyPage.id — NOT NULL

QuestionOption (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • option_text (varchar(255)) — VARCHAR(255) — NOT NULL
  • option_order (Field) — INTEGER — NOT NULL
  • question_id (Key2) — Long — Foreign key → Question.id — NOT NULL

Question_follow_up (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • parent_question_id (Key2) — Long — Foreign key → Question.id — NOT NULL
  • child_question_id (Key3) — Long — Foreign key → Question.id — NOT NULL

Survey (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • survey_name (Field) — VARCHAR(255) — NOT NULL

SurveyMetaData (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • surveyDescription (Field)
  • id (Key2) — Long — Foreign key → Survey.id — NOT NULL

SurveyPage (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • page_number (Field) — Integer — NOT NULL
  • page_title (Field2) — VARCHAR(200) — NOT NULL
  • survey_by_time_id (Key2) — Foreign key → Survey_time.id — NOT NULL

Survey_notification_times (Untitled6)

  • notification_time (Field2) — String — NOT NULL
  • survey_metadata_id (Key) — Long — Foreign key → SurveyMetaData.id — NOT NULL

Survey_time (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • time (Field) — VARHCAR(255) — NOT NULL
  • survey_id (Key2) — Long — Foreign key → Survey.id — NOT NULL

followup_conditions (Untitled9)

  • question_follow_up_id (Key) — Foreign key → Question_follow_up.id — NOT NULL
  • condition_values (Field2)