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 | Block height containing this transaction. |
block_time | TIMESTAMPTZ | UTC timestamp of the block. |
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); null for non-creation. |
gas_used | NUMERIC(78) | Gas consumed by this transaction. |
effective_gas_price_wei | NUMERIC(78) | Effective gas price paid in wei. |
status_success | BOOLEAN | Execution status: TRUE if successful, FALSE if reverted. |
root | BYTEA | Pre-Byzantium: state root (32 bytes) after tx execution; NULL for Byzantium+. |
tx_type | SMALLINT | Type of transaction (e.g., 2=EIP-1559, 1=legacy). |
trace_failed | BOOLEAN | TRUE if trace failed, FALSE if succeeded, NULL if trace not available. |
value_wei | NUMERIC | Value transferred in wei. |
input | BYTEA | Calldata sent with the transaction. |
nonce | BIGINT | Sender nonce. |
gas_limit | NUMERIC | Gas limit provided by the sender. |
gas_price_wei | NUMERIC | Gas price in wei (legacy). |
max_fee_per_gas_wei | NUMERIC | Max fee per gas (EIP-1559). |
max_priority_fee_per_gas_wei | NUMERIC | Max priority fee per gas (EIP-1559). |
_tracing_id | BYTEA | Tracing ID of the genesis tx record. |
_created_at | TIMESTAMPTZ | Record creation timestamp. |
_updated_at | TIMESTAMPTZ | Record last update timestamp. |
