Message Attachment
Defines the structure of the message attachment table
Table
Name: message_attachments
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_attachment_url
Description: The file path of the attachment
Data Type: Varchar(255)
Nullable: No
message_attachment_uploaded_r2
Description: Indicates whether the message attachment is uploaded to Cloudflare R2
Data Type: Tinyint - Default: 0
Nullable: No
message_attachment_stored_locally
Description: Indicates whether the message attachment is stored locally on the server
Data Type: Tinyint - Default: 0
Nullable: No
message_attachment_last_access
Description: The date and time when the message attachment was last accessed
Data Type: Timestamp
Nullable: Yes
message_attachment_size
Description: The size of the message attachment, measured in megabytes (MB)
Data Type: Decimal(8,2)
Nullable: No
message_attachment_added_to_album
Description: Indicates whether the message attachment is added to the gallery album
Data Type: Tinyint - Default: 0
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