Message Reacted User
Defines the structure of the message reacted user table
Table
Name: message_reacted_users
Columns
id (Primary Key)
Description: The unique identifier of the table
Data Type: Unsigned bigint
Nullable: No
user_id (Foreign Key)
Description: The user unique identifier
Data Type: Unsigned bigint
Nullable: No
Table: User
message_reaction_id (Foreign Key)
Description: The message reaction unique identifier
Data Type: Unsigned bigint
Nullable: No
Table: Message Reaction
message_reacted_status
Description: The status of the user reaction
Data Type: Unsigned integer - Default: 1
Nullable: No
Value:
- Reaction Removed - 0
- Reacted - 1
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