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