tx_hash | BYTEA | Keccak-256 hash of the transaction (32 bytes) |
from_address | BYTEA | Sender address (20 bytes) |
to_address | BYTEA | Recipient address (null for contract creation, 20 bytes if present) |
block_number | BIGINT | Canonical block height within the originating chain. |
tx_index | INTEGER | Zero-based index of the transaction within the block; directly verified by RLP |
created_contract_address | BYTEA | Contract address created by this transaction (20 bytes) |
gas_used | BIGINT | Gas consumed by this transaction; indirectly verified by RLP (calcualte cumulative gas from it) |
effective_gas_price_wei | NUMERIC(38,0) | Effective gas price paid in wei |
status_success | BOOLEAN | Execution status: TRUE if successful, FALSE if reverted, NULL for pre-Byzantium; directly verified by RLP |
root | BYTEA | Pre-Byzantium: state root (32 bytes) after tx execution; NULL for Byzantium+; directly verified by RLP |
tx_type | SMALLINT | Type of transaction (e.g., 2=EIP-1559, 1=legacy) |
_tracing_id | BYTEA | Tracing ID of the genesis tx record. |
_created_at | TIMESTAMPTZ | Record creation timestamp. |
_updated_at | TIMESTAMPTZ | Record last update timestamp. |
