> ## 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 Evm 🌱

### Table Details

| Property     | Value                         |
| ------------ | ----------------------------- |
| Table Name   | `hedera.raw.transactions_evm` |
| Table Status | Beta 🌱                       |
| Unique Key   | `transaction_hash`            |

### Table Columns

| Column Name                       | Data Type         | Description                                                                                                                                   |
| --------------------------------- | ----------------- | --------------------------------------------------------------------------------------------------------------------------------------------- |
| block\_number                     | NUMBER(38,0)      | Sequential number of the block that contains this transaction. Starts at 0 (genesis block) and increments by 1 for each new block.            |
| block\_hash                       | VARCHAR(16777216) | Cryptographic hash of the block header that contains this transaction. Uniquely identifies a block.                                           |
| consensus\_timestamp              | TIMESTAMP\_NTZ(9) | The consensus timestamp on Hedera, expressed as nanoseconds since Unix epoch. Hedera uses nanosecond precision for transaction ordering.      |
| transaction\_hash                 | VARCHAR(16777216) | Hash of the transaction. Uniquely identifies a transaction within the blockchain.                                                             |
| transaction\_id                   | VARCHAR(16777216) | Hedera transaction ID in the format `{payer_account_id}@{seconds}.{nanoseconds}`. Uniquely identifies a transaction.                          |
| nonce                             | NUMBER(38,0)      | Number of transactions sent from the sender's address prior to this one. Used to prevent replay attacks and ensure transaction ordering.      |
| result                            | VARCHAR(16777216) | Result code of the Hedera transaction (e.g. `SUCCESS`, `INSUFFICIENT_ACCOUNT_BALANCE`).                                                       |
| transaction\_type                 | VARCHAR(16777216) | Ethereum transaction envelope type. 0 = Legacy, 1 = Access List (EIP-2930), 2 = EIP-1559 dynamic fee.                                         |
| payer\_account\_id                | VARCHAR(16777216) | Hedera account ID of the account that paid the transaction fee.                                                                               |
| entity\_id                        | VARCHAR(16777216) | Hedera entity ID in the format `{shard}.{realm}.{num}` (e.g. `0.0.12345`). Identifies accounts, contracts, tokens, and other Hedera entities. |
| charged\_tx\_fee                  | NUMBER(38,0)      | Transaction fee charged in tinybars (1 HBAR = 100,000,000 tinybars).                                                                          |
| max\_fee                          | NUMBER(38,0)      | Maximum fee the sender authorizes for this transaction.                                                                                       |
| memo                              | VARCHAR(16777216) | Optional short memo string associated with this transaction.                                                                                  |
| scheduled                         | BOOLEAN           | True if this Hedera transaction was executed as part of a scheduled transaction.                                                              |
| node                              | VARCHAR(16777216) | Hedera node account ID that submitted this transaction to the network.                                                                        |
| valid\_duration\_seconds          | NUMBER(38,0)      | Maximum number of seconds this transaction is valid after its valid\_start\_timestamp.                                                        |
| parent\_consensus\_timestamp      | TIMESTAMP\_NTZ(9) | Consensus timestamp of the parent transaction that spawned this child transaction.                                                            |
| valid\_start\_timestamp           | TIMESTAMP\_NTZ(9) | Earliest timestamp at which this Hedera transaction may be submitted to the network.                                                          |
| contract\_result                  | VARIANT           | ABI-encoded return value and execution metadata of the Hedera smart contract call.                                                            |
| bytes                             | VARCHAR(16777216) | Raw transaction bytes as submitted to the network.                                                                                            |
| transfers                         | VARIANT           | JSON array of HBAR transfers (credits and debits) included in this transaction.                                                               |
| token\_transfers                  | VARIANT           | JSON array of fungible token transfers included in this transaction.                                                                          |
| nft\_transfers                    | VARIANT           | JSON array of NFT serial number transfers included in this transaction.                                                                       |
| staking\_reward\_transfers        | VARIANT           | JSON array of HBAR staking reward distributions included in this transaction.                                                                 |
| consensus\_timestamp\_raw         | NUMBER(29,9)      | Raw nanosecond consensus timestamp before conversion to a standard timestamp type.                                                            |
| parent\_consensus\_timestamp\_raw | NUMBER(29,9)      | Raw nanosecond parent consensus timestamp before conversion to a standard timestamp type.                                                     |
| valid\_start\_timestamp\_raw      | NUMBER(29,9)      | Raw nanosecond valid start timestamp before conversion to a standard timestamp type.                                                          |
| log\_count                        | NUMBER(38,0)      | Number of event logs emitted in the transaction.                                                                                              |
| extra\_evm\_fields                | VARIANT           | Additional EVM execution fields not present in standard Hedera transaction records (e.g., access lists).                                      |
| \_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.                                                                                 |