Table Description
Theberachain.transactions table contains information about all transactions on the Berachain blockchain. Each row represents a single transaction and includes information such as block number, hash, timestamp, sender, recipient, value, gas, and gas price. Berachain’s EVM-identical architecture ensures full compatibility with Ethereum tooling while leveraging its Proof-of-Liquidity (PoL) mechanism for enhanced efficiency.
Column Descriptions
| Column | Type | Description |
|---|---|---|
block_time | timestamp | Timestamp of the block containing this transaction |
block_number | bigint | Block number containing this transaction |
value | decimal | Amount of native token transferred (in wei) |
gas_limit | bigint | Maximum gas the sender is willing to use |
gas_price | bigint | Price per gas unit (in wei) |
gas_used | bigint | Actual gas consumed by the transaction |
max_fee_per_gas | bigint | Maximum total fee per gas (EIP-1559) |
max_priority_fee_per_gas | bigint | Maximum priority fee (tip) per gas (EIP-1559) |
priority_fee_per_gas | bigint | Actual priority fee per gas paid |
nonce | bigint | Transaction count of the sender before this transaction |
index | bigint | Position of the transaction within the block |
success | boolean | Whether the transaction executed successfully |
from | varbinary | Address of the transaction sender |
to | varbinary | Address of the transaction recipient |
block_hash | varbinary | Hash of the block containing this transaction |
data | varbinary | Calldata sent with the transaction |
hash | varbinary | Unique hash of the transaction |
type | varchar | Transaction type (legacy, EIP-2930, EIP-1559, EIP-4844) |
access_list | array(row) | List of addresses and storage keys accessed (EIP-2930) |
block_date | date | Date of the block (UTC) |
blob_versioned_hashes | array(varbinary) | Versioned hashes of blobs (EIP-4844) |
max_fee_per_blob_gas | bigint | Maximum fee per blob gas (EIP-4844) |
authorization_list | array(row) | Authorization list for EIP-7702 transactions |