Group Chat

Defines the structure of the group chat table

Table

Name: group_chats

Columns

id (Primary Key)

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

event_id (Foreign Key)

Description: The event unique identifier
Data Type: Unsigned bigint
Nullable: No
Table: Event

group_chat_name

Description: The name of the group chat
Data Type: Varchar(255)
Nullable: No

Note

The group_chat_name is auto-generated since it is connected to the event name.

group_chat_status

Description: The status of the group chat
Data Type: Tinyint
Nullable: No

Note

The group_chat_status is currently not used, but it might be useful in the future. Its current value is 1, which indicates that the group chat is active.

group_chat_ably_sent_at

Description: Indicates when the notification is sent using the Ably service
Data Type: Timestamp
Nullable: Yes

Note

In the current build, group_chat_ably_sent_at is not used, as all notifications are sent through the FCM service.

group_chat_push_sent_at

Description: Indicates when the notification is sent using the FCM service
Data Type: Timestamp
Nullable: Yes

Note

In the current build, group_chat_push_sent_at is not used because we are utilizing the RateLimiter facade in Laravel.

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