Task #101
Updated by Dana Basheer 21 days ago
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