MLA Portal

Stores details of the MLA associated with each constituency. Only one MLA profile is allowed per constituency.

***Table: mla_profiles

id BIGINT (PK) MLA profile ID
constituency_id BIGINT (FK → constituencies.id) Linked constituency
mla_name_ml VARCHAR(200) MLA name in Malayalam
mla_name_en VARCHAR(200) MLA name in English
party VARCHAR(100) Political party
photo TEXT MLA photo URL
tenure_start DATE Start of tenure
tenure_end DATE End of tenure
biography_ml TEXT Biography in Malayalam
contact_email VARCHAR(150) Contact email
contact_phone VARCHAR(15) Contact number
created_at TIMESTAMP Profile creation date

***Validations

*One MLA per constituency (unique constraint)

*MLA name in Malayalam is mandatory

*Party name required

*Contact details must be valid

*Tenure dates must be logical