MLA Portal

It involves developing a module that allows citizens to submit feedback and grievances related to their constituency. The system should securely collect user details, verify submissions using OTP, and store messages in Malayalam. Admin users can view, reply to, and update the status of each submission to ensure proper tracking and resolution.

***public_opinions

Field Type Description
id BIGINT (PK) Opinion ID
constituency_id BIGINT (FK) Related constituency
user_id BIGINT (FK, nullable) Linked user
name VARCHAR(150) Citizen name
mobile VARCHAR(15) Mobile number
subject_ml VARCHAR(255) Subject in Malayalam
message_ml LONGTEXT Message content
category VARCHAR(100) Complaint category
attachment TEXT Attached file
status ENUM('NEW','IN_REVIEW','RESOLVED') Complaint status
admin_reply_ml LONGTEXT Admin reply
replied_by BIGINT (FK → users.id) Admin responder
replied_at TIMESTAMP Reply time
created_at TIMESTAMP Submission date

***Validations

*Mobile number mandatory

*OTP verification required

*Message must be in Malayalam

*Status can be NEW, IN_REVIEW, or RESOLVED