VishwaVivah

The Search Module allows users to find profiles based on selected search criteria such as:

• Age range
• Location (State, District)
• Education
• Occupation
• Marital status
• Star / Raasi

This module enables users to manually search profiles beyond automatic match recommendations.

Table

Table Used

registration_table

Field Description

• id Profile internal ID
• profile_id Public ID (VMMYY####)
• name Name
• dob Used to calculate age
• city_id Location
• education_id Education
• occupation_id Occupation
• marital_status_id Marital status

profile_photo_table

• profile_id Profile reference
• photo_path Primary photo
• is_primary Primary photo flag

Optional Search Filter Log Table

search_log_table

Field Name Data Type Description

• id INT PK
• profile_id INT User who searched
• search_parameters TEXT Filters used
• search_date DATETIME Search time

Validations

Age Search

• Minimum age: 18
• Maximum age: 80
• age_min must be less than age_max

Location Search

• district_id must belong to state_id
• city_id must belong to district_id

Master Data Validation

These must exist in master tables:

• education_id
• occupation_id
• marital_status_id
• star_id
• raasi_id

Profile Visibility Rules

Search must show only:

• is_active = true profiles

Rules

• User cannot see inactive profiles
• User cannot see own profile in search results
• Search results must respect privacy settings (future scope)
• Default search shows recommended profiles