Create Migration for tables related to survey administration

[sheilaramas]

Description

- Create migration to add survey_templates table.

• [ ] id (PK)
• [ ] name
• [ ] display_name
• [ ] survey_type
• [ ] remarks
• [ ] is_active
• [ ] created_by_id
• [ ] updated_by_id
• [ ] created_at
• [ ] updated_at
• [ ] deleted_at

- Create migration to add survey_template_questions table.

• [ ] id (PK)
• [ ] FK to survey_templates table
• [ ] sequence_no
• [ ] question_type
• [ ] question_text
• [ ] is_required
• [ ] is_active
• [ ] created_by_id
• [ ] updated_by_id
• [ ] created_at
• [ ] updated_at
• [ ] deleted_at

- Create migration to add survey_template_question_rules table.

• [ ] id (PK)
• [ ] FK to survey_templates table
• [ ] FK to survey_template_questions table
• [ ] rule_key
• [ ] rule_value [string]
• [ ] remarks
• [ ] is_active
• [ ] created_by_id
• [ ] updated_by_id
• [ ] created_at
• [ ] updated_at
• [ ] deleted_at

- Create migration to add survey_template_answers table.

• [ ] id (PK)
• [ ] FK to survey_templates table
• [ ] FK to survey_template_questions table
• [ ] sequence_no
• [ ] answer_text
• [ ] amount
• [ ] answer_image
• [ ] is_active
• [ ] created_by_id
• [ ] updated_by_id
• [ ] created_at
• [ ] updated_at
• [ ] deleted_at

- Create migration for new table survey_administrations with the following fields:

• [ ] id (PK)
• [ ] name
• [ ] survey_start_date
• [ ] survey_end_date
• [ ] survey_template_id
• [ ] remarks
• [ ] email_subject
• [ ] email_content
• [ ] status
• [ ] created_by_id
• [ ] updated_by_id
• [ ] created_at
• [ ] updated_at
• follow evaluation_administrations field's types, lengths etc.

- Create migration to add survey_results table.

• [ ] id (PK)
• [ ] FK to survey_administration table
• [ ] FK to users table
• [ ] remarks
• [ ] status
• [ ] created_by_id
• [ ] updated_by_id
• [ ] created_at
• [ ] updated_at

- Create migration to add survey_answers table

• [ ] id (PK)
• [ ] FK to survey_administration table
• [ ] FK to survey_results table
• [ ] FK to users table
• [ ] FK to survey_templates table
• [ ] FK to survey_template_questions table [question]
• [ ] FK to survey_template_answers table [answer]
• [ ] remarks
• [ ] status
• [ ] created_by_id
• [ ] updated_by_id
• [ ] created_at
• [ ] updated_at

[gborgonia-ir]

Verified in Beta 🚀