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

# Transactions 🌱

### Table Details

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

### Table Columns

| Column Name           | Data Type         | Description                                                                   |
| --------------------- | ----------------- | ----------------------------------------------------------------------------- |
| 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.                 |

### Related Docs

* [Solana Raw Transactions](/historical-data/supported-blockchains/solana/solana/raw/transactions)