VishwaVivah

Sub Caste Master is a reference/master module used to store and manage sub-caste values under a specific community (e.g., Viswakarma).
It ensures data consistency, accurate filtering, and controlled dropdown values across the matrimony platform.

**Table
**
sub_caste_master

Field Name Data Type Key Description

• id INT PK Unique identifier for each sub-caste
• sub_caste_name VARCHAR — Name of the sub-caste
• is_active BOOLEAN — Status of the sub-caste (Active / Inactive)

Validation

Add/ Edit Subcaste

• Name Mandatory
• Minimum 2 characters
• Maximum 100 characters
• Alphabets and spaces only
• Must be unique
• Duplicate check must be case-insensitive
• Leading and trailing spaces should be trimmed

Delete

• Hard delete should NOT be allowed
• Soft delete must be used instead of hard delete
• Soft delete should be handled using is_active = false
• If sub caste is already used in any user profile:
  * Delete option should be disabled
  * Only deactivate option should be available

Activate / Deactivate

• Admin should be able to activate or deactivate sub caste
• Confirmation popup should be shown before status change
• When is_active = false:
  * Sub caste should NOT appear in user dropdowns
  * Existing user profiles should still display the sub caste
• When is_active = true:
  * Sub caste should be available for selection

Status(is_active)

• Mandatory
• Default value should be Active (true)
• Allowed values: true / false only
• Null value should not be allowed