| block_slot | NUMBER(38,0) | Slot of the block containing this transaction. |
| block_height | NUMBER(38,0) | Height of the block containing this transaction. |
| block_timestamp | TIMESTAMP_NTZ(9) | Estimated production time of the containing block, as Unix timestamp. |
| block_hash | VARCHAR(16777216) | Blockhash of the containing block. |
| txn_id | VARCHAR(16777216) | The transaction signature (unique identifier). |
| txn_index | NUMBER(38,0) | Position of this transaction within its block. |
| signatures | VARIANT | List of all signatures on this transaction (first is the fee payer’s). |
| fee | NUMBER(38,0) | Transaction fee in lamports. |
| err | VARCHAR(16777216) | Error information if the transaction failed, null on success. |
| account_keys | VARIANT | List of all account addresses referenced by the transaction (in order). |
| recent_block_hash | VARCHAR(16777216) | Recent blockhash used to anchor this transaction in time and prevent replay. |
| signer | VARCHAR(16777216) | The primary signer (fee payer) of the transaction. |
| log_messages | VARIANT | Array of program log messages emitted during execution. |
| pre_token_balances | VARIANT | SPL token balances of relevant accounts before the transaction. |
| post_token_balances | VARIANT | SPL token balances of relevant accounts after the transaction. |
| pre_balances | VARIANT | SOL balances (in lamports) of accounts before the transaction. |
| post_balances | VARIANT | SOL balances (in lamports) of accounts after the transaction. |
| success | BOOLEAN | True if the transaction succeeded (err is null). |
| is_voting | BOOLEAN | True if this is a consensus vote transaction. |
| instruction_count | NUMBER(38,0) | Number of top-level instructions in the transaction. |
| mint_to_decimals | VARIANT | Map from SPL token mint address to its decimal precision for tokens involved. |
| token_accounts | VARIANT | List of token account addresses involved in the transaction. |
| sol_amounts | VARIANT | Map of SOL balance deltas (lamports) per account index. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
