VishwaVivah

The Interest Module allows users to express interest in another profile.
It is the first step before communication (messaging).

Flow:

• User views a match
• Clicks Send Interest
• Other user can:
  • Accept
  • Reject

Only after interest is accepted, messaging can be enabled.

Table

user_interest_table

• id INT PK Unique interest ID
• sender_profile_id INT FK Profile sending interest
• receiver_profile_id INT FK Profile receiving interest
• interest_status VARCHAR — Pending / Accepted / Rejected
• sent_date DATETIME — Interest sent date
• responded_date DATETIME — Accepted / Rejected date
• is_active BOOLEAN — Status

Validations

• sender_profile_id
• Mandatory
• Must exist in registration_table
• Must be active profile
• Cannot send interest to own profile

receiver_profile_id

• Mandatory
• Must exist in registration_table
• Must be active profile

Duplicate Interest Check

• Same sender cannot send interest twice to same receiver
• Prevent duplicate records

interest_status

• Default value: Pending
• Allowed values:
  • Pending
  • Accepted
  • Rejected

sent_date

• Auto-generated
• Cannot be edited

responded_date

• Auto-generated when Accepted or Rejected

is_active

• Default value: true

Send Interest

• User can send interest to any matched profile
• Status becomes: Pending

Accept Interest

• Receiver accepts interest
• Status becomes: Accepted
• Messaging enabled

Reject Interest

• Receiver rejects interest
• Status becomes: Rejected
• Messaging disabled