Task #97
Updated by Dana Basheer 22 days ago
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