Description:
Represents the core messages within the platform (a transactional notification log). Tracks message creation, topic, and the notification subscription a message belongs to.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the message. |
created_at |
TIMESTAMP_TZ | Timestamp when the message was created. |
topic |
TEXT | The topic or subject of the message. |
created_by |
NUMBER | Identifier of the user who created the message. |
notification_subscription_code |
TEXT | Code of the notification subscription this message relates to. |
_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. |