Key schemas

[DenisCarriere]

Transactions

• gas_used or gas?

StreamingFast & Dune uses gas_used

• input or data?

Quicknode & Dune uses data https://www.quicknode.com/guides/ethereum-development/smart-contracts/a-dive-into-evm-architecture-and-opcodes#understanding-evm-transaction-execution

Erigon uses GetData type https://github.com/erigontech/erigon/blob/820abe5b7928cf487e7e44dfd0b18d985979e008/core/types/transaction.go#L79C2-L79C9

• when input is empty, 0x or "" (blank)?

provide 0x if data is stored as binary, "" if type is String

Traces (calls)

• index or subtraces?
• suicide or selfdestruct?
• address or trace_address?
• gas_consumed or gas_used?
• index or sub_traces

System Traces

• Do we include extra tables(e.g. logs, balance_changes, storage_changes, code_changes, account_creations, nonce_changes, gas_changes)?

  would require to drop transaction from those tables

Balance Changes

• delta_value or amount?
• old_value or old_balance?
• new_value or new_balance?

new_value:    6113231490000000000
old_value:    6101024403000000000
delta_value:  12207087000000000