VishwaVivah

City Master is a reference/master table used to maintain the list of cities under each district for the matrimony platform.

Table

city_table

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

Validation

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 the selected state_id
• Must be active
• Cannot be NULL

city_name

• Mandatory (NOT NULL)
• Minimum 2 characters
• Maximum 100 characters
• Alphabetic characters and spaces only
• No leading or trailing spaces
• Must be unique within the same district

is_active

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

Add

• City can be added only under an active district and state

Edit

• Only city_name correction allowed
• state_id and district_id must not be changed
• Existing user mappings must not break

Delete

• Not Allowed
• City is linked to user profiles and search filters
• Hard delete can cause data inconsistency

Activate / Deactivate

• Use is_active = false instead of delete