Table Details
| Property | Value |
|---|---|
| Table Name | solana.decoded.idl |
| Table Status | Beta 🌱 |
| Unique Key | program_id, pseudo_global_order |
| Search Optimization | program_id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| 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. |
| program_id | VARCHAR(16777216) | Base58-encoded public key of the Solana program that processed this instruction (e.g. TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA for SPL Token). |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| 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. |
| txn_index | NUMBER(38,0) | Zero-based position of this transaction within its slot. |
| idl | VARCHAR(16777216) | Full Interface Definition Language (IDL) JSON schema for this program version, used to decode instruction and event data. |
| idl_sig | VARCHAR(16777216) | Hash signature of the IDL JSON content, used for integrity checking and deduplication. |
| pseudo_global_order | NUMBER(38,0) | Internal ordering key combining block slot and transaction index to define a globally-consistent event ordering on Solana. Used for incremental processing and deduplication. |
| idl_rank | NUMBER(18,0) | Ordinal rank of this IDL version in the program’s deployment history (1 = earliest). |
| is_valid_anchor_idl | BOOLEAN | Whether this IDL conforms to valid Anchor IDL format (as opposed to a manually curated schema). |
| nearest_prev_upgrade_block_slot | NUMBER(38,0) | Slot of the previous program upgrade before this IDL record, used to bound the IDL’s validity window. |
| nearest_prev_upgrade_txn_index | NUMBER(38,0) | Transaction index of the previous program upgrade in its slot. |
| nearest_next_upgrade_block_slot | NUMBER(38,0) | Slot of the next program upgrade after this IDL record, used to bound the IDL’s validity window. |
| nearest_next_upgrade_txn_index | NUMBER(38,0) | Transaction index of the next program upgrade in its slot. |