VishwaVivah

The Profile Viewed Notification Module tracks and notifies users when another member views their profile.

This feature helps users:

• Know who viewed their profile
• Increase engagement
• Encourage sending interests

Table

profile_view_notification_table

• id INT PK Unique notification ID
• viewer_profile_id INT FK Profile who viewed
• viewed_profile_id INT FK Profile who was viewed
• viewed_date DATETIME — Date and time of view
• is_read BOOLEAN — Notification read status
• is_active BOOLEAN — Status

Validations

viewer_profile_id

• Mandatory
• Must exist in registration_table
• Must be active profile
• Cannot view own profile

viewed_profile_id

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

viewed_date

• Auto-generated
• Cannot be NULL
• Cannot be future date

is_read

• Default value: false

• Changes to true when user opens notification

• is_active

• Default value: true