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)