VishwaVivah

Education Master is a reference/master table used to maintain the list of educational qualifications in the matrimony platform.
It ensures standardized qualification data and avoids free-text entry errors.

Table

education_table

• id INT PK Unique identifier for each education
• education_name VARCHAR — Name of the education qualification
• is_active BOOLEAN — Status of the education

Validation

id

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

education_name

• Mandatory (NOT NULL)
• Minimum 2 characters
• Maximum 100 characters
• Alphabetic characters, spaces, and dots allowed (Example: B.Tech, M.Sc)
• No leading or trailing spaces
• Must be unique
• Duplicate education names not allowed

is_active

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

Add

• Admin can add new education qualifications

Edit

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

Delete

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

Activate / Deactivate

• Use is_active = false instead of delete