> ## 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_testnet.raw.transactions` |
| Table Status      | Beta 🌱                           |
| Unique Key        | `txn_id`, `block_timestamp`       |
| Clustering Key(s) | `to_date("block_timestamp")`      |

### 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.                       |
| compute\_units\_consumed | NUMBER(38,0)      | Total compute units consumed by the transaction.                              |
| cost\_units              | NUMBER(38,0)      | Total cost units (Solana's transaction scheduling cost) consumed by the txn.  |
| \_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)