VishwaVivah

District Master is a reference/master table used to maintain the list of districts under each state for the matrimony platform.

Table

district_table

• id INT PK Unique identifier for each district
• state_id INT FK References State Master (id)
• district_name VARCHAR — Name of the district
• is_active BOOLEAN — Status of the district

Validation

id

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

state_id

• Mandatory
• Must exist in State Master
• Only active states allowed
• Cannot be NULL

district_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 state

is_active

• Mandatory
• Default value: true
• Accepts only boolean values
• Cannot be NULL

Add

• District can be added only under an active state

Edit

• Only district_name correction allowed
• state_id must not be changed once created
• Existing user mappings must not break

Delete

• District is linked to:
• Cities
• User profiles
• Hard delete can break hierarchy and data integrity

Activate / Deactivate

• Use is_active = false instead of delete