Message
Defines the structure of the table
Table
Name: messages
Columns
id (Primary Key)
Description: The unique identifier of the messages table
Data Type: Unsigned bigint
Nullable: No
user_id (Foreign Key)
Description: The user unique identifier
Data Type: Unsigned bigint
Nullable: No
Table: User
group_chat_id (Foreign Key)
Description: The group chat unique identifier
Data Type: Unsigned bigint
Nullable: No
Table: User
message_content
Description: The content of the message
Data Type: Longtext
Nullable: No
message_reply_id
Description: The ID of the message to which the user replied
Data Type: Bigint
Nullable: Yes
Table: 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