| hash | VARCHAR(64) | Unique identifier of the transaction |
| signature | VARIANT | Digital signature(s) of the transaction |
| contract_ret | VARCHAR(16777216) | Contract return status (e.g., SUCCESS) |
| ret | VARCHAR(16777216) | Return value of the contract execution |
| raw_data_hex | VARCHAR(16777216) | Raw transaction data in hexadecimal format |
| type | VARCHAR(16777216) | Type of the transaction (e.g., TransferContract) |
| type_url | VARCHAR(16777216) | URL of the transaction type definition |
| owner_address_hex | VARCHAR(16777216) | Hexadecimal representation of the transaction initiator’s address |
| owner_address | VARCHAR(16777216) | Base58 representation of the transaction initiator’s address |
| to_address_hex | VARCHAR(16777216) | Hexadecimal representation of the recipient’s address |
| to_address | VARCHAR(16777216) | Base58 representation of the recipient’s address |
| amount | VARCHAR(16777216) | Amount of TRX or tokens transferred |
| asset_name_hex | VARCHAR(16777216) | Hexadecimal representation of the asset name (for token transfers) |
| asset_name | VARCHAR(8388608) | Name of the asset being transferred (for token transfers) |
| contract_address_hex | VARCHAR(16777216) | Hexadecimal representation of the contract address (for contract interactions) |
| contract_address | VARCHAR(16777216) | Base58 representation of the contract address (for contract interactions) |
| data | VARCHAR(16777216) | Additional data included in the transaction |
| parameter_value | VARIANT | JSON string containing transaction parameters |
| expiration | VARCHAR(16777216) | Expiration timestamp of the transaction |
| fee_limit | VARCHAR(16777216) | Maximum fee the sender is willing to pay |
| ref_block_bytes | VARCHAR(16777216) | Reference block bytes |
| ref_block_hash | VARCHAR(16777216) | Reference block hash |
| timestamp | VARCHAR(16777216) | Timestamp when the transaction was created |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block containing this transaction |
| block_number | NUMBER(38,0) | Block number containing this transaction |
| block_hash | VARCHAR(16777216) | Hash of the block containing this transaction |
| parent_hash | VARCHAR(16777216) | Hash of the parent block |
| version | VARCHAR(16777216) | Version of the transaction |
| tx_trie_root | VARCHAR(16777216) | Merkle root of the transaction trie |
| witness_address | VARCHAR(16777216) | Address of the block producer (witness) |
| witness_signature | VARCHAR(16777216) | Signature of the block producer (witness) |
| has_receipts | BOOLEAN | Boolean indicating if the transaction has receipts |
| receipt_json | VARIANT | JSON string containing receipt details |
| unfreeze_amount | NUMBER(38,0) | Amount unfrozen in this transaction |
| withdraw_amount | NUMBER(38,0) | Amount withdrawn in this transaction |
| withdraw_expire_amount | NUMBER(38,0) | Expired withdrawal amount |
| receipt_contract_address_hex | VARCHAR(16777216) | Hexadecimal representation of the contract address in the receipt |
| receipt_contract_address | VARCHAR(16777216) | Base58 representation of the contract address in the receipt |
| receipt_contract_result | VARIANT | Result of the contract execution |
| receipt_fee | NUMBER(38,0) | Total fee charged for the transaction |
| receipt_net_fee | NUMBER(38,0) | Network fee charged for the transaction |
| receipt_net_usage | NUMBER(38,0) | Network resources used by the transaction |
| receipt_energy_fee | NUMBER(38,0) | Energy fee charged for the transaction |
| receipt_energy_usage_total | NUMBER(38,0) | Total energy used by the transaction |
| receipt_energy_usage | NUMBER(38,0) | Energy used by the transaction execution |
| receipt_origin_energy_usage | NUMBER(38,0) | Energy used by the contract owner |
| receipt_res_message | VARIANT | Resource message in the receipt |
| receipt_result | VARCHAR(16777216) | Result status in the receipt |
| parameter_json | VARIANT | JSON string containing parsed transaction parameters |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when this record was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when this record was last updated |
| _extra_fields | VARIANT | Additional fields not covered by the standard schema |
