> ## 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.

# Instructions 🌱

### Table Details

| Property            | Value                                                                                 |
| ------------------- | ------------------------------------------------------------------------------------- |
| Table Name          | `solana_devnet.raw.instructions`                                                      |
| Table Status        | Beta 🌱                                                                               |
| Unique Key          | `txn_id`, `instruction_index`                                                         |
| Clustering Key(s)   | `to_date("block_timestamp")`                                                          |
| Search Optimization | `txn_id`, `txn_index`, `instruction_index`, `program_id`, `program_name`, `is_voting` |

### Table Columns

| Column Name               | Data Type         | Description                                                                              |
| ------------------------- | ----------------- | ---------------------------------------------------------------------------------------- |
| block\_slot               | NUMBER(38,0)      | Slot of the block containing this instruction.                                           |
| block\_height             | NUMBER(38,0)      | Height of the block containing this instruction.                                         |
| 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 (id) this instruction belongs to.                              |
| txn\_index                | NUMBER(38,0)      | Position of the transaction within its block.                                            |
| instruction\_index        | NUMBER(38,0)      | Position of this instruction within its transaction.                                     |
| program\_id               | VARCHAR(16777216) | The program (smart contract) account that executes this instruction.                     |
| parsed                    | VARCHAR(16777216) | Parsed/decoded JSON form of the instruction data, if recognised by Solana's parser.      |
| program\_name             | VARCHAR(16777216) | Human-readable name of the program, if known.                                            |
| accounts                  | VARIANT           | List of account addresses referenced by this instruction (in order).                     |
| data                      | VARCHAR(16777216) | Raw instruction data, base58-encoded.                                                    |
| parsed\_type              | VARCHAR(16777216) | The instruction type tag from the parsed JSON (e.g. "transfer", "createAccount").        |
| is\_voting                | BOOLEAN           | True if the parent transaction is a consensus vote transaction.                          |
| parent\_tx\_success       | BOOLEAN           | True if the parent transaction succeeded.                                                |
| parent\_tx\_signer        | VARCHAR(16777216) | Primary signer (fee payer) of the parent transaction.                                    |
| inner\_instruction\_count | NUMBER(38,0)      | Number of inner instructions produced by this outer 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) | Raw instruction data as a hex string.                                                    |
| data\_hex\_first2         | VARCHAR(16777216) | First 2 hex characters (1 byte) of the data — commonly the instruction discriminator.    |
| data\_hex\_first16        | VARCHAR(16777216) | First 16 hex characters (8 bytes) of the data — commonly the Anchor/borsh discriminator. |

### Related Docs

* [Solana Raw Instructions](/historical-data/supported-blockchains/solana/solana/raw/instructions)