Message Mention

Defines the structure of the message mention table

Table

Name: message_mentions

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

user_id (Foreign Key)

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

message_mention_position

Description: The position of the mentioned user in the message
Data Type: Unsigned 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