Notification

Defines the structure of the notifications table

Table

Name: notifications

Columns

id (Primary Key)

Description: The unique identifier of the notifications table
Data Type: Unsigned bigint
Nullable: No

user_id (Foreign Key)

Description: The user unique identifier
Data Type: Unsigned bigint
Nullable: No
Table: User

notification_type

Description: The timestamp when the record is created
Data Type: Unsigned tinyint
Nullable: No
Values:

• Event: 1
• Event Deletion: 2
• Friend Request: 3
• Event Invitation: 4
• Event Deletion: 5
• Leave Event: 6
• Guest Invitation Declined: 7
• Guest Attending: 8
• Guest Interested: 9
• Guest Accepted: 10
• Guest Removed: 11
• Friend Request Accepted: 12
• Guest Requested to Join: 13
• Guest Request is Approved: 14
• Guest Going: 15
• Guest Joined: 16
• Event Liked: 17
• Gallery Comment: 18
• Gallery Comment Mention: 19
• Gallery Comment Replied: 20
• Gallery Comment Reaction: 21
• Gallery Photo Liked: 22

notification_item_id

Description: The ID of the item (e.g., if the notification type is “Event” the ID will correspond to the Event ID)
Data Type: Unsigned tinyint
Nullable: No

notification_mark_as_read

Description: Indicates whether the notification is marked as read
Data Type: Unsigned tinyint - Default: 0
Nullable: No

notification_data

Description: The metadata of the notification
Data Type: Unsigned tinyint
Nullable: No

Note

The value of this is a JSON string:

{
    //This is sample
    "event_id": 0,
    "user_id": 0
}

This is used to retrieve the information of the item, as it will be mapped by the backend into a readable message.

created_at

Description: The timestamp when the record is created
Data Type: Timestamp
Nullable: Yes

updated_at

Description: The timestamp when the record is updated
Data Type: Timestamp
Nullable: Yes