VishwaVivah

State Master is a reference/master table used to maintain a standardized list of states for the matrimony platform.

Table

state_table

• id INT PK Unique identifier for each state
• state_name VARCHAR — Name of the state
• is_active BOOLEAN — Status of the state

Validation

id

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

state_name

• Mandatory (NOT NULL)
• Minimum 2 characters
• Maximum 100 characters
• Must be unique (case-insensitive)
• Alphabetic characters and spaces only
• No leading or trailing spaces
• Duplicate state names not allowed

is_active

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

Add

• Allowed
• Used for initial setup and future additions

Edit

• Allowed (Restricted)
• Only state_name correction allowed
• State id must never change
• If state is already mapped to districts or profiles, editing should not break existing mappings

Delete

• Not Allowed
• States are parent records in the location hierarchy
• Deleting can break district, city, and user profile data

Activate / Deactivate

• Allowed
• Use is_active = false instead of delete