Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
Table Details
| Property | Value |
|---|---|
| Table Name | ton_testnet.raw.transactions |
| Table Status | Beta 🌱 |
| Unique Key | utime, hash |
| Clustering Key(s) | to_date("utime") |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| account | VARCHAR(16777216) | The account involved in the transaction. |
| account_state_after | VARIANT | The state of the account after the transaction. |
| account_state_before | VARIANT | The state of the account before the transaction. |
| workchain | NUMBER(38,0) | The workchain identifier where the transaction occurred. |
| shard | VARCHAR(16777216) | The shard identifier where the transaction occurred. |
| seqno | NUMBER(38,0) | The sequence number of the transaction. |
| aborted | BOOLEAN | Indicates if the transaction was aborted. |
| action | VARIANT | Details of the action performed in the transaction. |
| compute_ph | VARIANT | Compute phase details of the transaction. |
| credit_first | BOOLEAN | Indicates if the transaction has a credit phase first. |
| credit_ph | VARIANT | Credit phase details of the transaction. |
| destroyed | BOOLEAN | Indicates if the account was destroyed. |
| storage_ph | VARIANT | Storage phase details of the transaction. |
| type | VARCHAR(16777216) | The type of the transaction. |
| end_status | VARCHAR(16777216) | The status of the account at the end of the transaction. |
| hash | VARCHAR(16777216) | The hash of the transaction. |
| in_msg_hash | VARCHAR(16777216) | The hash of the inbound message associated with the transaction. |
| lt | NUMBER(38,0) | The logical time of the transaction. |
| mc_block_seqno | NUMBER(38,0) | The masterchain block sequence number. |
| utime | TIMESTAMP_NTZ(9) | The Unix timestamp of the transaction. |
| orig_status | VARCHAR(16777216) | The original status of the account before the transaction. |
| out_msgs_count | NUMBER(38,0) | The count of outbound messages generated by the transaction. |
| prev_trans_hash | VARCHAR(16777216) | The hash of the previous transaction. |
| prev_trans_lt | NUMBER(38,0) | The logical time of the previous transaction. |
| total_fees | NUMBER(38,0) | The total fees paid for the transaction. |
| transaction_index | NUMBER(38,0) | The index of the transaction within the block. |
| in_msg | VARIANT | The full inbound message that triggered the transaction, including source, destination, value, and body payload. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update. |