IC-BE-Survey-ERD

Tables (5)

Untitled3

  • id (Key) — char(36) — Primary key — NOT NULL
  • survey_answer_id (Key2) — char(36) — Foreign key → survey_answer.id — NOT NULL
  • answer (Field) — varchar
  • created_at (Field2) — datetime

survey_answer (Untitled)

  • id (Key) — char(36) — Primary key — NOT NULL
  • survey_item_id (Key3) — char(36) — Foreign key → survey_itme.survey_form_id — NOT NULL
  • created_at (char(36)) — char(36)

survey_form (Untitled2)

  • id (Key) — char(36) — Primary key — NOT NULL
  • title (Field) — varchar
  • description (Field2) — varchar
  • version (Field3) — int
  • created_at (Field4) — datetime

survey_itme (CopyOfUntitled)

  • id (Key2) — char(36) — Primary key — NOT NULL
  • survey_form_id (Key) — char(36) — Foreign key → survey_form.id — NOT NULL
  • is_required (Field) — Boolean
  • name (Field2) — varchar
  • description (Field3) — varchar
  • type (Field4) — enum
  • created_at (Field5) — datetime

survey_option (CopyOfCopyOfUntitled)

  • id (Key3) — char(36) — Primary key — NOT NULL
  • survey_item_Id (Key) — char(36) — Foreign key → survey_itme.survey_form_id — NOT NULL
  • name (Field) — varchar
  • created_at (Field2) — datetime