MLA Portal

This module manages the MLA’s future vision and planned projects for upcoming years.

***future_plans

Field Type Description
id BIGINT (PK) Plan ID
constituency_id BIGINT (FK) Related constituency
title_ml VARCHAR(255) Plan title in Malayalam
description_ml LONGTEXT Plan description
target_year YEAR Target completion year
estimated_budget DECIMAL(12,2) Estimated budget
priority ENUM('LOW','MEDIUM','HIGH') Plan priority
created_by BIGINT (FK → users.id) Admin who created
created_at TIMESTAMP Created date

***validations

*Title and description required

*Target year must be future or current year

*Estimated budget must be positive

*Priority must be LOW, MEDIUM, or HIGH