Beta Migration Guide

PreviousETH Data Model (Beta)NextUseful info - types and layers

Last updated 1 year ago

Summary of changes:

RAW and DECODED schemas are no longed necessary. All tables are available in a new database schema called MARKETPLACE.
Business data such as Transfers and Tokens are available in the same database and schema.
Raw and decoded tables have been merges into single tables for all entities. A "decoded" column is present to flag the status of the decoding process.
Columns have been renamed, removed or added across all tables. Specific details and mapping to the new column are provided for each table to facilitate changing queries.

Changes in the data model

Once you have moved the new database you can follow the details below to update your queries. Make sure that you also update the name of the database and the schema. Need help? Reach out to our team.

Blocks

New columns

Column

Data Type

Layer

Nullable

Definition

Existing columns

Calls

New Columns

Existing Columns

Events

New Columns

Existing Columns

State_diffs

New Columns

Existing Columns

Storage_diffs

New Columns

Existing Columns

Transactions

New Columns

No new columns have been added to this table

Existing Columns

Transfers

New Columns

No new columns have been added to this table.

Existing Columns

Tokens

New Columns

No new columns have been added to this table.