MLA Portal

This module maintains the master list of Kerala Assembly constituencies. Each constituency includes Malayalam and English names, district details, and map coordinates.

***Table: table_constituencies

constituency_id BIGINT (PK) Constituency ID
name_ml VARCHAR(200) Constituency name in Malayalam
name_en VARCHAR(200) Constituency name in English
district VARCHAR(100) District name
assembly_no INT Assembly number
map_lat DECIMAL(10,8) Latitude coordinate
map_lng DECIMAL(11,8) Longitude coordinate
status ENUM('ACTIVE','INACTIVE') Constituency status
created_at TIMESTAMP Created date

***Validations

*Constituency name (Malayalam) is mandatory

*Assembly number must be unique

*Latitude & longitude must be valid decimals

*Status must be ACTIVE or INACTIVE