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

### Table Columns

| Column Name        | Data Type         | Description                                                                                           |
| ------------------ | ----------------- | ----------------------------------------------------------------------------------------------------- |
| block\_height      | NUMBER(38,0)      | The sequential number of the block in the blockchain.                                                 |
| block\_timestamp   | TIMESTAMP\_NTZ(9) | The timestamp when the block was created.                                                             |
| block\_hash        | VARCHAR(16777216) | The hash of the block containing the transaction.                                                     |
| hash               | VARCHAR(16777216) | The hash of the transaction.                                                                          |
| transaction\_index | NUMBER(38,0)      | The index of the transaction within the block.                                                        |
| code               | NUMBER(38,0)      | The code returned after the transaction execution (e.g., 0 for success).                              |
| codespace          | VARCHAR(16777216) | The namespace for the error codes.                                                                    |
| gas\_used          | VARCHAR(16777216) | The amount of gas used for the transaction.                                                           |
| gas\_wanted        | VARCHAR(16777216) | The amount of gas requested for the transaction.                                                      |
| tx\_acc\_seq       | VARCHAR(16777216) | The sequence number of the account used in the transaction.                                           |
| tx\_fee\_payer     | VARCHAR(16777216) | The address of the account paying the transaction fee.                                                |
| tx\_fee\_raw       | VARCHAR(16777216) | The raw fee data for the transaction, containing both amount and denomination.                        |
| fee\_amount        | VARCHAR(16777216) | The fee amount for the transaction.                                                                   |
| fee\_denom         | VARCHAR(16777216) | The denomination of the fee amount.                                                                   |
| event\_count       | NUMBER(38,0)      | The number of events associated with the transaction.                                                 |
| log                | VARCHAR(16777216) | The log of the transaction execution in string format. Use `try_parse_json` to fetch the log details. |
| info               | VARCHAR(16777216) | Additional information about the transaction.                                                         |
| tx                 | VARCHAR(16777216) | The transaction details in a serialized format.                                                       |
| data               | VARCHAR(16777216) | The data returned from the transaction execution.                                                     |
| \_created\_at      | TIMESTAMP\_NTZ(9) | The timestamp when the entry was created.                                                             |
| \_updated\_at      | TIMESTAMP\_NTZ(9) | The timestamp when the entry was updated.                                                             |

### Related Docs

* [COSMOS Raw Transactions](/historical-data/supported-blockchains/cosmos-ecosystem/core-schemas/raw/transactions)