Table Details
| Property | Value |
|---|---|
| Table Name | ton.raw.messages |
| Table Status | Production-Ready |
| Unique Key | utime, hash |
| Clustering Key(s) | to_date("utime") |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| workchain | NUMBER(38,0) | The workchain identifier where the message was sent. |
| shard | VARCHAR(16777216) | The shard identifier where the message was sent. |
| seqno | NUMBER(38,0) | The sequence number of the message. |
| bounce | BOOLEAN | Indicates if the message should be bounced back to the sender if it fails. |
| bounced | BOOLEAN | Indicates if the message was bounced back to the sender. |
| utime | TIMESTAMP_NTZ(9) | The Unix timestamp when the message was created. |
| created_lt | NUMBER(38,0) | Logical time when the message was created. |
| fwd_fee | NUMBER(38,0) | The forward fee associated with the message. |
| hash | VARCHAR(16777216) | The hash of the message. |
| ihr_disabled | BOOLEAN | Indicates if the Instant Hypercube Routing (IHR) is disabled. |
| ihr_fee | NUMBER(38,0) | The fee associated with the IHR. |
| import_fee | NUMBER(38,0) | The import fee associated with the message. |
| init_state | VARIANT | The initial state of the message. |
| masterchain_seqno | NUMBER(38,0) | The sequence number of the masterchain block. |
| message_content | VARIANT | The content of the message. |
| message_index | NUMBER(38,0) | The index of the message within the block. |
| opcode | VARCHAR(16777216) | The operation code associated with the message. |
| source | VARCHAR(16777216) | The source address of the message. |
| transaction_hash | VARCHAR(16777216) | The hash of the associated transaction. |
| value | NUMBER(38,0) | The value transferred by the message. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update. |
| destination | VARCHAR(16777216) | The destination address of the message. |