VishwaVivah

Star Master is a reference/master table used to store astrological Nakshatra (Star) names for matrimony profiles. It ensures standardized astrological data, avoids free-text errors, and supports accurate matchmaking and filtering.

Table

star_master

Field Name Data Type Key Description

• id INT PK Unique identifier for each star
• star_name VARCHAR — Name of the star (Nakshatra)
• is_active BOOLEAN — Status of the star

Validation

id

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

star_name

• Mandatory field (NOT NULL)
• Minimum length: 2 characters
• Maximum length: 100 characters
• Must be unique (case-insensitive)
• Only alphabetic characters and spaces allowed
• Leading and trailing spaces should be trimmed

is_active

• Boolean value only (true / false)

• Default value: true

• Cannot be NULL

• Only active stars should be displayed in user dropdowns

• Inactive stars:
  * Should not be selectable for new profiles
  * Should still appear for existing user profiles

• Stars already used in user profiles must not be deleted

• Admin can only activate or deactivate such stars