| 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. |
