Aye Aye Aung #77: Election Managment - Questionnaires - MMVOTE (vue3 + Laravel 11) - Redmine

Actions

Copy link

Aye Aye Aung #77

open

Election Managment - Questionnaires

Added by Aye Aye Aung about 1 year ago. Updated about 1 year ago.

Status:

Resolved

Priority:

Critical

Assignee:

Aung Tin

Start date:

01/09/2025

Due date:

01/09/2025 (about 13 months late)

% Done:

100%

Estimated time:

Description

If admin choose questionnaire eletion type while election created, input data will change relevant data.
election_questionnaires_tbl
id (BIGINT UNSIGNED)
election_id (BIGINT UNSIGNED) -- Foreign key referencing election_tbl.id
question (TEXT)
question_type (ENUM: 'yes_no', 'multiple_choice')
options (JSON) -- For multiple choice (nullable for others)
is_required (BOOLEAN)
created_at (TIMESTAMP)
updated_at (TIMESTAMP)

Actions

Copy link

Updated by Aye Aye Aung about 1 year ago

If the admin want to add question details on each question, they can add many question details. [ one to many ]
election_questionnaires_details_tbl

id (BIGINT UNSIGNED)
question_id (BIGINT UNSIGNED)
image (VARCHAR(255))
name (VARCHAR(255))
bio (TEXT)
created_at (TIMESTAMP)
updated_at (TIMESTAMP)

Actions

Copy link

Updated by Aye Aye Aung about 1 year ago

Just create database table because this table will use from voter side.
election_questionnaire_responses_tbl

id (BIGINT UNSIGNED)
election_voter_id (BIGINT UNSIGNED) -- Foreign key referencing election_voters.id
questionnaire_id (BIGINT UNSIGNED) -- Foreign key referencing election_questionnaires_tbl.id
response (TEXT) -- yes or no / multiple_choice
created_at (TIMESTAMP)
updated_at (TIMESTAMP)