> ## 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 | `tron_nile.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(34) | The address of the sending party of this transaction. |
| from\_address\_evm | VARCHAR(42) | From address EVM of the transaction. |
| from\_address\_hex | VARCHAR(42) | Hex-encoded sender address (Tron base58 address decoded to hex). |
| to\_address | VARCHAR(34) | The address of the receiving party of this transaction (could be a contract address). |
| to\_address\_evm | VARCHAR(42) | EVM-compatible 20-byte address derived from the destination, used on chains with dual addressing schemes. |
| to\_address\_hex | VARCHAR(42) | Hex-encoded recipient address (Tron base58 address decoded to hex). |
| value | NUMBER(38,0) | 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(34) | The contract address created, if the transaction was a contract creation, otherwise null. |
| receipt\_contract\_address\_evm | VARCHAR(42) | Receipt contract address EVM of the transaction. |
| receipt\_contract\_address\_hex | VARCHAR(42) | Receipt contract address hex of the transaction. |
| 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)