> ## 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          | `casper.raw.transactions`                 |
| Table Status        | Production-Ready                          |
| Unique Key          | `block_timestamp`, `block_height`, `hash` |
| Clustering Key(s)   | `to_date("block_timestamp")`              |
| Search Optimization | `hash`, `block_height`, `initiator`       |

### Table Columns

| Column Name                | Data Type         | Description                                                                                           |
| -------------------------- | ----------------- | ----------------------------------------------------------------------------------------------------- |
| hash                       | VARCHAR(16777216) | Hash of the transaction.                                                                              |
| transaction\_index         | NUMBER(38,0)      | Index of the transaction within the block.                                                            |
| transaction\_result        | VARCHAR(16777216) | Execution result of the transaction (e.g., Success or Failure).                                       |
| initiator                  | VARCHAR(16777216) | Account that signed and initiated the transaction.                                                    |
| cost                       | VARCHAR(16777216) | Total motes charged for the transaction.                                                              |
| gas\_price                 | NUMBER(38,0)      | Per-transaction gas price tolerance (Version1); null for legacy Deploy transactions.                  |
| gas\_consumed              | VARCHAR(16777216) | Computational gas units consumed during execution.                                                    |
| gas\_limit                 | VARCHAR(16777216) | Maximum gas units the transaction is allowed to consume.                                              |
| gas\_refund                | VARCHAR(16777216) | Motes refunded to the initiator after execution.                                                      |
| current\_price             | NUMBER(38,0)      | Block-level current gas price active when the transaction was included.                               |
| size\_estimate             | NUMBER(38,0)      | Estimated serialized size of the transaction in bytes.                                                |
| error\_message             | VARCHAR(16777216) | Error message if the transaction failed; null on success.                                             |
| approvals                  | VARIANT           | List of signatures (signer plus signature) authorizing the transaction.                               |
| header                     | VARIANT           | Transaction header metadata (chain name, timestamp, ttl, etc.).                                       |
| payment                    | VARIANT           | Payment logic with motes amount; populated for legacy `Deploy` transactions only.                     |
| payload                    | VARIANT           | Full transaction body (args, target, pricing, initiator); populated for `Version1` transactions only. |
| session                    | VARIANT           | Session code or stored contract call; populated for legacy `Deploy` transactions only.                |
| api\_version               | VARCHAR(16777216) | Node API version that produced the transaction payload.                                               |
| era\_id                    | NUMBER(38,0)      | Era (epoch) the block belongs to.                                                                     |
| block\_timestamp           | TIMESTAMP\_NTZ(9) | Timestamp of the block this event was included in.                                                    |
| block\_height              | NUMBER(38,0)      | Height of the block this event was included in.                                                       |
| block\_hash                | VARCHAR(16777216) | Hash of the block this event was included in.                                                         |
| operation\_count           | NUMBER(38,0)      | Number of operations recorded for this transaction.                                                   |
| transform\_count           | NUMBER(38,0)      | Number of state transforms produced by this transaction.                                              |
| native\_transfer\_count    | NUMBER(38,0)      | Number of native CSPR transfers triggered by this transaction.                                        |
| transaction\_version       | VARCHAR(16777216) | Casper transaction format: `Deploy` (legacy) or `Version1` (Casper 2.0).                              |
| execution\_result\_version | VARCHAR(16777216) | Execution result format version (e.g., `ExecutionResultV2`).                                          |
| \_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.                                         |