VishwaVivah

The Registration Table stores the core personal, astrological, family, location, and professional details of a matrimony user. This table acts as the foundation of the entire matrimony system, as all matching, searching, and filtering depend on this data. Each record represents one matrimonial profile, whether created for self or on behalf of someone else.

Table

registration_table

• id INT PK Unique profile identifier
• profile_for ID FK Profile created for (Myself, Daughter, Son, etc.)
• name VARCHAR — Full name of the candidate
• mobile_no VARCHAR — Primary contact number
• dob DATE — Date of birth
• mother_tongue VARCHAR — Native language
• email_id VARCHAR — Email address
• willing_to_marry_from ID FK Sub-caste preference
• star ID FK Birth star
• raasi ID FK Birth raasi
• suddha_jathakam ID FK Horoscope availability
• time_of_birth TIME — Time of birth
• state ID FK State
• district ID FK District
• city ID FK City
• location VARCHAR — Area / locality
• marital_status ID FK Marital status
• height VARCHAR — Height
• family_status ID FK Economic background
• family_type ID FK Joint / Nuclear
• physical_status ID FK Physical condition
• qualification ID FK Educational qualification
• employed_in ID FK Employment sector
• occupation ID FK Job role
• work_location VARCHAR — Work place
• description TEXT — About the profile
• added_date DATETIME — Profile creation date

Validation

General

• One user can have only one active profile
• All dropdown-based fields must fetch values from master tables
• No free-text allowed where master data exists

profile_for

• Mandatory
• Allowed values only:
• Myself, Daughter, Son, Sister, Brother, Relative, Friend

name

• Mandatory
• Minimum 3 characters
• Maximum 100 characters
• Alphabetic characters and spaces only

mobile_no

• Mandatory
• Must be exactly 10 digits
• Numbers only
• Must be unique

dob

• Mandatory
• Cannot be a future date
• Age must be 18+

mother_tongue

• Mandatory
• Alphabetic only

email_id

• Mandatory
• Must be valid email format
• Must be unique

willing_to_marry_from

• Mandatory
• Allowed values only:
• Same Subcaste, Other Subcaste Also

star

• Mandatory
• Must exist in Star Master
• Only active stars allowed

raasi

• Mandatory
• Must exist in Raasi Master
• Only active raasi allowed

suddha_jathakam

• Mandatory
• Allowed values only
• Yes, No, Don’t Know

time_of_birth

• Optional
• Valid time format (HH:MM)

state / district / city

• Mandatory
• Must follow hierarchy (State → District → City)

location

• Optional
• Max 150 characters

marital_status

• Mandatory
• Allowed values only:
• Unmarried, Widow, Divorced, Separated

height

• Mandatory
• Valid human-readable format (e.g., 5.6 ft)

family_status

• Mandatory
• Allowed values only:
• Middle Class, Upper Middle Class, Rich/Affluent

family_type

• Mandatory
• Allowed values only:
• Joint Family, Nuclear Family

physical_status

• Mandatory
• Allowed values only:
• Normal, Physically Challenged

qualification / employed_in / occupation

• Mandatory
• Must exist in respective master tables

work_location

• Optional
• Max 150 characters

description

• Optional
• Max 1000 characters
• No HTML or script allowed

added_date

• Auto-generated

• System date & time

• Profile is visible in search only after mandatory fields are completed

• Inactive master values must:
  * Not be selectable
  * Still display for existing profiles

• Phone number & email must remain private

• Profile edits should be tracked (audit-ready)