VishwaVivah

The Message Notification Module alerts users when they receive a new message from another profile.

When a user sends a message, the system automatically creates a notification for the receiver so they know someone has contacted them

Table

message_notification_table

• id INT PK Unique notification ID
• sender_profile_id INT FK Profile who sent the message
• receiver_profile_id INT FK Profile receiving message
• message_id INT FK Reference message
• notification_text VARCHAR(300) — Notification message
• is_read BOOLEAN — Read status
• created_at DATETIME — Notification created time
• is_active BOOLEAN — Status

Validations

sender_profile_id

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

receiver_profile_id

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

message_id

• Mandatory
• Must exist in user_message_table

notification_text

• Mandatory
• Maximum length: 300 characters

is_read

• Default value: false
• Becomes true when user opens message

created_at

• Auto-generated timestamp

is_active

• Default value: true