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