| anchor_mode | VARCHAR(16777216) | Specifies how the transaction is anchored to the Bitcoin chain (on_chain_only, off_chain_only, any). |
| block_hash | VARCHAR(16777216) | The hash of the block containing the transaction. |
| block_height | NUMBER(38,0) | The height of the block containing the transaction. |
| miner_block_time | TIMESTAMP_NTZ(9) | The timestamp set by the miner when producing the block. |
| burn_block_height | NUMBER(38,0) | Height of the burn chain block. |
| burn_block_time | TIMESTAMP_NTZ(9) | Timestamp when the corresponding burn block was mined. |
| canonical | BOOLEAN | Indicates if the transaction is in the canonical chain. |
| event_count | NUMBER(38,0) | The number of events generated by the transaction. |
| execution_cost_read_count | NUMBER(38,0) | Execution cost read count. |
| execution_cost_read_length | NUMBER(38,0) | Execution cost read length. |
| execution_cost_runtime | NUMBER(38,0) | Execution cost runtime. |
| execution_cost_write_count | NUMBER(38,0) | Execution cost write count. |
| execution_cost_write_length | NUMBER(38,0) | Execution cost write length. |
| fee_rate | NUMBER(38,0) | The fee rate for the transaction. |
| is_unanchored | BOOLEAN | Indicates if the transaction is unanchored. |
| microblock_canonical | BOOLEAN | Indicates if the transaction is in a canonical microblock. |
| microblock_hash | VARCHAR(16777216) | The hash of the microblock containing the transaction. |
| microblock_sequence | NUMBER(38,0) | The sequence number of the microblock. |
| nonce | NUMBER(38,0) | The nonce used by the transaction sender. |
| parent_block_hash | VARCHAR(16777216) | The hash of the parent block. |
| parent_burn_block_time | TIMESTAMP_NTZ(9) | Timestamp of the parent burn block. |
| post_condition_mode | VARCHAR(16777216) | The post condition mode for the transaction (allow, deny). |
| post_conditions | VARIANT | The post conditions specified in the transaction. |
| sender_address | VARCHAR(16777216) | The address of the transaction sender. |
| sponsored | BOOLEAN | Indicates if the transaction is sponsored. |
| tx_id | VARCHAR(16777216) | The unique identifier or hash of the transaction. |
| tx_index | NUMBER(38,0) | The index of the transaction within the block. |
| tx_result | VARIANT | The result of the transaction execution. |
| tx_status | VARCHAR(16777216) | The status of the transaction (success, abort_by_response, abort_by_post_condition). |
| tx_type | VARCHAR(16777216) | The type of transaction (e.g., token_transfer). |
| tx_contents | VARIANT | The contents of the transaction. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update. |
| true_event_count | NUMBER(38,0) | The true count of events. |
