VishwaVivah

Occupation Master is a reference/master table used to maintain the list of job roles / occupations in the matrimony platform.
It ensures standardized occupation data and prevents free-text inconsistencies.

Table

occupation_table

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

Validations

id

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

occupation_name

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

is_active

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

Add

• Admin can add new occupations

Edit

• Only occupation_name correction allowed
• Must not break existing user profile mappings

Delete

• Occupation is linked to user profiles
• Hard delete may cause data inconsistency

Activate / Deactivate

• Use is_active = false instead of delete