| block_slot | NUMBER(38,0) | Solana slot number in which this transaction was confirmed. Slots are the fundamental unit of time on Solana (analogous to block numbers on EVM chains). Not every slot produces a block. |
| block_height | NUMBER(38,0) | Number of confirmed blocks between this block and the genesis block (inclusive). Unlike block_slot, this only increments for slots that produced a block. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_hash | VARCHAR(16777216) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| txn_id | VARCHAR(16777216) | Base58-encoded transaction signature on Solana. Analogous to transaction_hash on EVM chains. Uniquely identifies a transaction. |
| txn_index | NUMBER(38,0) | Zero-based position of this transaction within its slot. |
| instruction_index | NUMBER(38,0) | Zero-based position of this instruction within the transaction’s top-level instructions array. |
| inner_instruction_index | NUMBER(38,0) | Zero-based position of this inner instruction within its parent instruction’s inner instructions array. -1 for top-level instructions that are not inner instructions. |
| program_id | VARCHAR(16777216) | Base58-encoded public key of the Solana program that processed this instruction (e.g. TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA for SPL Token). |
| parsed | VARCHAR(16777216) | Parsed decoded representation of this instruction as JSON when the program IDL is known |
| program_name | VARCHAR(16777216) | Human-readable name of the Solana program (e.g. “spl_token”, “system_program”, “jupiter_v6”). Resolved from Allium’s program registry. |
| accounts | VARIANT | Array of account addresses referenced by this instruction |
| data | VARCHAR(16777216) | ABI-encoded non-indexed parameters of an event log, or the calldata of a transaction/trace. Decode using the relevant ABI to extract individual field values. |
| parsed_type | VARCHAR(16777216) | Type name of the parsed instruction (e.g., transfer, mintTo, createAccount) |
| is_voting | BOOLEAN | True if this transaction is a validator vote transaction |
| parent_tx_success | BOOLEAN | True if the parent transaction of this inner instruction succeeded |
| parent_tx_signer | VARCHAR(16777216) | Fee payer address of the parent transaction that spawned this inner instruction |
| parent_instruction_program_id | VARCHAR(16777216) | Program ID of the parent instruction that invoked this inner instruction |
| _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. |
| data_hex | VARCHAR(16777216) | Instruction data as a hexadecimal string |
| data_hex_first16 | VARCHAR(16777216) | First 16 bytes of instruction data as hex, used for instruction type identification |
| data_hex_first2 | VARCHAR(16777216) | First 2 bytes of instruction data as hex |
| stack_height | NUMBER(38,0) | Nesting depth of this instruction (1 for top-level instructions, incrementing for each level of inner instructions). |
| _extra_fields | VARIANT | JSON string with platform-specific metadata. |
