VishwaVivah

Locality Master is a reference/master table used to maintain the list of local areas/localities under each city in the matrimony platform.
It provides more precise location information beyond city level and improves search accuracy and profile relevance.

Table

locality_master

• id INT PK Unique identifier for each locality
• state_id INT FK References State Master (id)
• district_id INT FK References District Master (id)
• city_id INT FK References City Master (id)
• locality_name VARCHAR — Name of the locality
• is_active BOOLEAN — Status of the locality

Validations

id

• Auto-increment
• Primary key
• Not editable from UI

state_id

• Mandatory
• Must exist in State Master
• Must be active
• Cannot be NULL

district_id

• Mandatory
• Must exist in District Master
• Must belong to selected state_id
• Must be active
• Cannot be NULL

city_id

• Mandatory
• Must exist in City Master
• Must belong to selected district_id
• Must be active
• Cannot be NULL

locality_name

• Mandatory (NOT NULL)
• Minimum 2 characters
• Maximum 150 characters
• Alphabetic characters and spaces allowed
• Numbers allowed (example: Area 1, Phase 2)
• No leading or trailing spaces
• Must be unique within the same city
• Duplicate locality names not allowed under same city

is_active

• Mandatory
• Default value: true
• Accepts only boolean values (true / false)
• Cannot be NULL

Add

• Locality can be added only under an active state, district, and city

Edit

• Only locality_name correction allowed
• state_id, district_id, and city_id must not be changed
• Should not affect existing user profiles

Delete

• Locality is linked to user profiles and search filters
• Hard delete may cause data inconsistency

Activate / Deactivate

• Use is_active = false instead of delete