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