VishwaVivah

Each user profile must have a unique Profile ID that is automatically generated by the system during registration.
This ID is used for identification, search, reference, and internal tracking.

Table

registration_table

• id INT PK Internal auto-increment ID
• profile_id VARCHAR UNIQUE Public unique profile ID

Validations

• Must be auto-generated
• Must be unique
• Must not be editable
• Must not be NULL
• Must be generated only after successful registration

Multiple Photo

Users must be able to upload multiple profile photos.
Photos improve profile trust and matching chances.

Table

profile_photo_table

• id INT PK Unique identifier
• profile_id INT FK References registration_table(id)
• photo_path VARCHAR — Stored file path
• is_primary BOOLEAN — Primary profile photo
• uploaded_date DATETIME — Upload timestamp
• is_active BOOLEAN — Photo status

Validations

• Minimum photos: 1

• Maximum photos: 5 (recommended)

• Allowed formats:

  • JPG
  • JPEG
  • PNG

• Max file size:

  • 5 MB per photo

• Only image files allowed

• One photo must be marked as primary

• Primary photo displayed in:

  • Profile card
  • Search results