VishwaVivah

Raasi Master is a reference/master table used to store Zodiac (Raasi) names required for astrological details in a matrimony platform. It ensures standardized zodiac data, avoids manual entry errors, and supports horoscope-based filtering and future compatibility logic.

Table

raashi_master

Field Name Data Type Key Description

• id INT PK Unique identifier for each raasi
• raasi_name VARCHAR — Name of the zodiac sign
• is_active BOOLEAN — Status of the raasi

Validation

id

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

raasi_name

• Mandatory (NOT NULL)
• Minimum 2 characters
• Maximum 100 characters
• Must be unique (case-insensitive)
• Alphabetic characters only
• No leading or trailing spaces
• Duplicate values not allowed

is_active

• Mandatory

• Default value: true

• Accepts only boolean values (true / false)

• Cannot be NULL

• Only active raasi values should appear in user dropdowns

• Inactive raasi should:
  *Not be selectable for new users
  *Still appear for existing user profiles

• Raasi records must not be deleted once linked to any user