Table Change Overview

A detailed overview of the column changes for each EVM Table.

Detailed Overview by Table

The below outlines the column changes for all EVM blockchains with specific notes for the change. The standard tables impacted are: fact_blocks, fact_transactions, fact_event_logs, fact_traces, ez_token_transfers, ez_native_transfers , and ez_nft_transfers .

Fact Blocks

Columns	Removed from	Added to	Renamed in	Reason for removal
BLOCK_HASH		ALL
BLOCKCHAIN	ALL			Redundant info
BLOCK_HEADER_JSON	ALL			Json column, already extracted all contents as individual columns
BASE_FEE_PER_GAS		ALL except Core
EXCESS_BLOB_GAS		Berachain, BSC, Ethereum
BLOB_GAS_USED		Berachain, BSC, Ethereum
STATE_ROOT		ALL
TRANSACTIONS_ROOT		ALL
LOGS_BLOOM		ALL
MINER		ALL except Ethereum and Gnosis
NONCE		ALL except Ethereum
WITHDRAWALS		Gnosis, Berachain, BSC
WITHDRAWALS_ROOT		Gnosis, Berachain, BSC
L1_STATE_ROOT_TX_HASH	Optimism			Only applies to Optimism
L1_STATE_ROOT_BATCH_INDEX	Optimism			Only applies to Optimism
L1_SUBMISSION_TX_HASH	Optimism			Only applies to Optimism
L1_SUBMISSION_BATCH_INDEX	Optimism			Only applies to Optimism
L1_SUBMISSION_DETAILS	Optimism			Only applies to Optimism

Fact Transactions

Columns	Removed from	Added to	Renamed in	Reason for removal
STATUS	ALL except Kaia			Changing to boolean version (TX_SUCCEEDED)
BLOCK_HASH	ALL
TX_SUCCEEDED		ALL except Kaia
CHAINID	Ethereum, Avalanche, Polygon			not a useful column
TX_TYPE		Base, Blast, Kaia, Sei evm, Dexalot, Berachain
TX_POSITION (renamed from POSITION)			All
BLOB_VERSIONED_HASHES		Berachain, BSC, Ethereum
MAX_FEE_PER_BLOB_GAS		Berachain, BSC, Ethereum
BLOB_GAS_USED		Berachain, BSC, Ethereum
BLOB_GAS_PRICE		Berachain, BSC, Ethereum
L1_SUBMISSION_BATCH_INDEX	Optimism			Only applies to Optimism.
L1_SUBMISSION_TX_HASH	Optimism			Only applies to Optimism.
L1_STATE_ROOT_BATCH_INDEX	Optimism			Only applies to Optimism.
L1_STATE_ROOT_TX_HASH	Optimism			Only applies to Optimism.
L1_SUBMISSION_DETAILS	Optimism, Base			Only applies to OP Stack.
DEPOSIT_NONCE	Optimism, Base, Blast			Only applies to OP Stack.
DEPOSIT_RECEIPT_VERSION	Optimism, Base, Blast			Only applies to OP Stack.
Y_PARITY		Blast

Fact Event Logs

Columns	Removed from	Added to	Renamed in	Reason for removal
TX_POSITION		ALL
TOPIC_0		ALL
TOPIC_1		ALL
TOPIC_2		ALL
TOPIC_3		ALL
TX_STATUS	ALL except Kaia, Dexalot, Berachain			Changing to boolean version (TX_SUCCEEDED)
TX_SUCCEEDED		ALL except Kaia, Dexalot, Berachain
_LOG_ID	ALL except Berachain			Removing because it's an internal column

Fact Traces

Columns	Removed from	Added to	Renamed in	Reason for removal
TX_POSITION		ALL except Kaia, Dexalot, Berachain
TRACE_ADDRESS		ALL except Dexalot
IDENTIFIER	ALL			Not that easy to use. Replacing this with TRACE_ADDRESS instead
DATA	ALL except Dexalot			Json column, already extracted all contents as individual columns
VALUE_HEX		ALL except Dexalot
ORIGIN_FROM_ADDRESS		ALL except Dexalot
ORIGIN_TO_ADDRESS		ALL except Dexalot
ORIGIN_FUNCTION_SIGNATURE		ALL except Dexalot
TRACE_STATUS	ALL except Kaia, Dexalot, Berachain			Changing to boolean version (TRACE_SUCCEEDED)
TRACE_SUCCEEDED		ALL except Kaia, Dexalot, Berachain
REVERT_REASON		ALL except Dexalot
IS_PENDING	Kaia			Removing because it's an internal column
TX_STATUS	ALL except Kaia, Dexalot, Berachain			Changing to boolean version (TX_SUCCEEDED)
TX_SUCCEEDED		ALL except Kaia, Dexalot, Berachain
_CALL_ID	Kaia			Removing because it's an internal column
_INSERTED_TIMESTAMP	Kaia			Removing because it's an internal column

EZ Token Transfers

Columns	Removed from	Added to	Renamed in	Reason for removal
TX_POSITION		ALL
TOKEN_STANDARD		ALL
NAME		ALL
TOKEN_PRICE	ALL			Redundant
HAS_DECIMAL	ALL			Redundant
HAS_PRICE	ALL			Redundant
_LOG_ID	ALL			internal column
_INSERTED_TIMESTAMP	ALL			internal column

EZ Native Transfers

Columns	Removed from	Added to	Renamed in	Reason for removal
TRACE_ADDRESS		ALL
TYPE		ALL
IDENTIFIER	ALL			Not easy to use, replacing with trace_address instead

EZ NFT Transfers

Columns	Removed from	Added to	Renamed in	Reason for removal
tx_position,		ALL
token_transfer_type,		ALL
is_mint,		ALL
from_address,		ALL
to_address,		ALL
contract_address,		ALL
token_id,		ALL
quantity,		ALL
token_standard,		ALL
name,		ALL
origin_function_signature,		ALL
origin_from_address,		ALL
origin_to_address,		ALL
nft_address	ALL		renamed to contract_address
tokenid	ALL		renamed to token_id
erc1155_value	ALL		renamed to quantity
event_type	ALL			replaced with is_mint column
project_name	ALL		renamed to name
nft_from_address	ALL		renamed to from_address
nft_to_address	ALL		renamed to to_address