public-data-docs

Table: MESSAGE_ATTACHMENTS

Description:

Links a message to an attached resource. Each row references either a file or an invoice (exactly one of file_id / invoice_id is set per row).

🔑 Primary Key

id

Field Name Data Type Description
id NUMBER Unique identifier for the message attachment.
message_id NUMBER Identifier of the message this attachment belongs to.
file_id NUMBER Identifier of the attached file, if the attachment is a file.
invoice_id NUMBER Identifier of the attached invoice, if the attachment is an invoice.
_snowflake_inserted_at TIMESTAMP_NTZ System timestamp when the record was inserted into Snowflake.
_snowflake_updated_at TIMESTAMP_NTZ System timestamp when the record was last updated in Snowflake.
_snowflake_deleted BOOLEAN True if the record was deleted in the source.