ERD for SSAFVEY
Tables (11)
job (Untitled4)
- id (Key) — Primary key — NOT NULL
- name (Field)
member (Untitled)
- id (Key) — Primary key — NOT NULL
- name (Field)
- gender (Field2)
- age (Field3)
- password (Field4)
- is_active (Field5)
member_answer_descriptive (Untitled10)
- id (Key) — Primary key — NOT NULL
- survey_question_id (Key2) — Foreign key → survey_question.id — NOT NULL
- answer (Field)
- distinct_uuid (Field2)
member_answer_multiple_choice (Untitled9)
- id (Key) — Primary key — NOT NULL
- survey_question_id (Key2) — Foreign key → survey_question.id — NOT NULL
- survey_content_order (Field)
- distinct_uuid (Field2)
member_job (Untitled11)
- member_id (Key) — Foreign key → member.id — NOT NULL
- job_id (Key2) — Foreign key → job.id — NOT NULL
member_survey (Untitled6)
- id (Key) — Primary key — NOT NULL
- member_id (Key3) — Foreign key → member.id — NOT NULL
- survey_id (Key2) — Foreign key → survey.id — NOT NULL
- created_at (Field)
- is_owner (Field2)
survey (Untitled2)
- id (Key) — Primary key — NOT NULL
- title (Field)
- create_date (Field2)
- target_survey_participants (Field4)
- target_gender (Field5)
- survey_participants (Field6)
- is_done (Field7)
- description (Field3)
- organization (Field8)
- end_date (Field9)
survey_question (Untitled7)
- id (Key) — Primary key — NOT NULL
- survey_id (Key2) — Foreign key → survey.id — NOT NULL
- order (Field)
- question (Field2)
- is_multiple_choice (Field3)
survey_question_choice (Untitled8)
- id (Key) — Primary key — NOT NULL
- survey_question_id (Key2) — Foreign key → survey_question.id — NOT NULL
- order (Field)
- choice_description (Field2)
- count (Field3)
survey_target_age (Untitled3)
- id (Key2) — Primary key — NOT NULL
- survey_id (Key) — Foreign key → survey.id — NOT NULL
- min_age (Field)
- max_age (Field2)
survey_target_job (Untitled5)
- id (Key2) — Primary key — NOT NULL
- survey_id (Key) — Foreign key → survey.id — NOT NULL
- job_id (Key3) — Foreign key → job.id — NOT NULL