Message Reaction
Defines the structure of the message reaction table
Table
Name: message_reactions
Columns
id (Primary Key)
Description: The unique identifier of the table
Data Type: Unsigned bigint
Nullable: No
message_id (Foreign Key)
Description: The message unique identifier
Data Type: Unsigned bigint
Nullable: No
Table: Message
message_reaction
Description: The path to the reaction in the a mobile emoji
Data Type: Varchar(255)
Nullable: No
message_reaction_count
Description: The number of reactions
Data Type: Integer
Nullable: No
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