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

### Table Columns

| Column Name                    | Data Type         | Description                                                                                                                           |
| ------------------------------ | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------- |
| hash                           | VARCHAR(66)       | Unique identifier of a transaction.                                                                                                   |
| nonce                          | NUMBER(38,0)      | [The transaction nonce, unique to the wallet](https://evm.org/en/glossary/#nonce)                                                     |
| transaction\_index             | NUMBER(38,0)      | The position of this transaction in the block that it belongs to. The first transaction has index 0.                                  |
| from\_address                  | VARCHAR(42)       | The address of the sending party of this transaction.                                                                                 |
| to\_address                    | VARCHAR(42)       | The address of the receiving party of this transaction (could be a contract address).                                                 |
| value                          | VARCHAR(16777216) | The amount of ether sent in this transaction, in wei.                                                                                 |
| gas                            | NUMBER(38,0)      | The maximum amount of gas allocated for this transaction in wei.                                                                      |
| gas\_price                     | NUMBER(38,0)      | Cost per unit of gas specified by the transaction in wei. The higher the gas price, the higher chance of getting included in a block. |
| input                          | VARCHAR(16777216) | The data sent along with the transaction.                                                                                             |
| receipt\_cumulative\_gas\_used | NUMBER(38,0)      | The total amount of gas used when this transaction was executed in the block.                                                         |
| receipt\_gas\_used             | NUMBER(38,0)      | The total amount of gas consumed by a transaction as recorded in its receipt                                                          |
| receipt\_contract\_address     | VARCHAR(42)       | The contract address created, if the transaction was a contract creation, otherwise null.                                             |
| receipt\_root                  | VARCHAR(66)       | Transaction stateroot (pre Byzantium).                                                                                                |
| receipt\_status                | NUMBER(38,0)      | Success status of the transaction. Either 1 (success) or 0 (failure).                                                                 |
| block\_timestamp               | TIMESTAMP\_NTZ(9) | The time when the block that contains this transaction was included on the blockchain.                                                |
| block\_number                  | NUMBER(38,0)      | The length of the chain, in blocks.                                                                                                   |
| block\_hash                    | VARCHAR(66)       | Unique identifier of the block that includes this transaction.                                                                        |
| transaction\_type              | NUMBER(38,0)      | The integer of the transaction type, 0x0 for legacy transactions, 0x1 for access list types, 0x2 for dynamic fees.                    |
| receipt\_effective\_gas\_price | NUMBER(38,0)      | The sum of the base fee and tip paid per unit of gas.                                                                                 |
| log\_count                     | NUMBER(38,0)      | Number of event logs emitted in the transaction.                                                                                      |
| \_created\_at                  | TIMESTAMP\_NTZ(9) | Timestamp of the entry creation.                                                                                                      |
| \_updated\_at                  | TIMESTAMP\_NTZ(9) | Timestamp of the entry update.                                                                                                        |

### Related Docs

* [EVM Raw Transactions](/historical-data/supported-blockchains/evm/core-schemas/raw/transactions)