MLA Portal

This module stores completed and ongoing development projects carried out in a constituency.

***table_developments

Field Type Description
id BIGINT (PK) Development ID
constituency_id BIGINT (FK) Related constituency
title_ml VARCHAR(255) Project title in Malayalam
description_ml LONGTEXT Project description
category VARCHAR(100) Category (Road, School, Hospital, etc.)
year YEAR Project year
budget DECIMAL(12,2) Project budget
status ENUM('COMPLETED','ONGOING') Project status
created_by BIGINT (FK → users.id) Admin who created
created_at TIMESTAMP Created date

***Validations

*Title and description must be in Malayalam

*Year must be valid

*Budget cannot be negative

*Status must be COMPLETED or ONGOING