> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Schema Deprecation & Migration Guide

> Deprecated schemas and their recommended alternatives. Applies to all Allium users querying legacy *.assets and common.prices schemas.

<Warning>
  **Important**: The schemas listed below are deprecated and will be removed by **December 18, 2025**. Please migrate to the recommended alternatives as soon as possible.
</Warning>

## Overview

Allium is deprecating legacy asset schemas across all major chains to simplify and standardize asset data tables.
The new schema family introduces consistent naming conventions across blockchains.

Starting **December 18, 2025**, the legacy schemas listed below will be deprecated and removed from allium catalog and respective shares. Please migrate to the new standardized schemas before this date.

<Info>
  **Key clarification**: The `fungible_*` tables (e.g., `fungible_token_transfers`, `fungible_balances`) contain **both native token (e.g., ETH, MATIC, AVAX) and ERC20 token data**. This was also the case with the legacy tables they replace. Use the `token_type` column to filter: `NATIVE` for native transfers, `ERC20` for ERC20 transfers.
</Info>

### Summary

| Chain                                                         | Legacy Prefix                              | New Schema Family                 |
| ------------------------------------------------------------- | ------------------------------------------ | --------------------------------- |
| ethereum                                                      | eth\_*, eth\_and\_erc20\_*, eth\_erc20\_\* | native\_*, fungible\_*            |
| arbitrum                                                      | eth\_*, eth\_erc20\_*                      | native\_*, fungible\_*            |
| base                                                          | eth\_*, eth\_erc20\_*                      | native\_*, fungible\_*            |
| mode                                                          | eth\_*, eth\_erc20\_*                      | native\_*, fungible\_*            |
| optimism                                                      | eth\_*, eth\_erc20\_*                      | native\_*, fungible\_*            |
| polygon                                                       | matic\_*, matic\_and\_erc20\_*, pol\_\*    | native\_*, fungible\_*            |
| polygon\_zkevm                                                | eth\_*, eth\_erc20\_*                      | native\_*, fungible\_*            |
| scroll                                                        | eth\_*, eth\_erc20\_*                      | native\_*, fungible\_*            |
| zora                                                          | eth\_*, eth\_erc20\_*                      | native\_*, fungible\_*            |
| avalanche                                                     | avax\_*, avax\_erc20\_*                    | native\_*, fungible\_*            |
| bsc                                                           | bnb\_*, bnb\_erc20\_*                      | native\_*, fungible\_*            |
| common.prices                                                 | token\_prices\_hourly\_easy                | common.prices.hourly              |
| ethereum.prices, arbitrum.prices, base.prices, polygon.prices | dex\_token\_prices\_hourly                 | {chain}.dex.token\_prices\_hourly |

### Table Mappings

<AccordionGroup>
  <Accordion title="Arbitrum Assets">
    | Legacy Table                                   | New Table                                  |
    | ---------------------------------------------- | ------------------------------------------ |
    | arbitrum.assets.eth\_balances\_latest          | arbitrum.assets.native\_balances\_latest   |
    | arbitrum.assets.eth\_balances                  | arbitrum.assets.native\_balances           |
    | arbitrum.assets.eth\_credit\_debit             | arbitrum.assets.native\_credit\_debit      |
    | arbitrum.assets.eth\_token\_transfers          | arbitrum.assets.native\_token\_transfers   |
    | arbitrum.assets.eth\_erc20\_balances\_latest   | arbitrum.assets.fungible\_balances\_latest |
    | arbitrum.assets.eth\_erc20\_balances           | arbitrum.assets.fungible\_balances         |
    | arbitrum.assets.eth\_erc20\_token\_transfers   | arbitrum.assets.fungible\_token\_transfers |
    | arbitrum.assets.unhydrated\_fungible\_balances | arbitrum.assets.fungible\_balances         |
  </Accordion>

  <Accordion title="Avalanche Assets">
    | Legacy Table                                    | New Table                                   |
    | ----------------------------------------------- | ------------------------------------------- |
    | avalanche.assets.avax\_balances                 | avalanche.assets.native\_balances           |
    | avalanche.assets.avax\_token\_transfers         | avalanche.assets.native\_token\_transfers   |
    | avalanche.assets.avax\_erc20\_balances          | avalanche.assets.fungible\_balances         |
    | avalanche.assets.avax\_erc20\_token\_transfers  | avalanche.assets.fungible\_token\_transfers |
    | avalanche.assets.unhydrated\_fungible\_balances | avalanche.assets.fungible\_balances         |
  </Accordion>

  <Accordion title="Base Assets">
    | Legacy Table                               | New Table                              |
    | ------------------------------------------ | -------------------------------------- |
    | base.assets.eth\_balances\_latest          | base.assets.native\_balances\_latest   |
    | base.assets.eth\_balances                  | base.assets.native\_balances           |
    | base.assets.eth\_credit\_debit             | base.assets.native\_credit\_debit      |
    | base.assets.eth\_token\_transfers          | base.assets.native\_token\_transfers   |
    | base.assets.eth\_erc20\_balances\_latest   | base.assets.fungible\_balances\_latest |
    | base.assets.eth\_erc20\_balances           | base.assets.fungible\_balances         |
    | base.assets.eth\_erc20\_token\_transfers   | base.assets.fungible\_token\_transfers |
    | base.assets.unhydrated\_fungible\_balances | base.assets.fungible\_balances         |
  </Accordion>

  <Accordion title="BSC Assets">
    | Legacy Table                            | New Table                             |
    | --------------------------------------- | ------------------------------------- |
    | bsc.assets.bnb\_balances                | bsc.assets.native\_balances           |
    | bsc.assets.bnb\_credit\_debit           | bsc.assets.native\_credit\_debit      |
    | bsc.assets.bnb\_token\_transfers        | bsc.assets.native\_token\_transfers   |
    | bsc.assets.bnb\_erc20\_balances         | bsc.assets.fungible\_balances         |
    | bsc.assets.bnb\_erc20\_token\_transfers | bsc.assets.fungible\_token\_transfers |
  </Accordion>

  <Accordion title="Ethereum Assets">
    | Legacy Table                                                                                    | New Table                                  |
    | ----------------------------------------------------------------------------------------------- | ------------------------------------------ |
    | ethereum.assets.eth\_balances\_latest                                                           | ethereum.assets.native\_balances\_latest   |
    | ethereum.assets.eth\_balances                                                                   | ethereum.assets.native\_balances           |
    | ethereum.assets.eth\_credit\_debit                                                              | ethereum.assets.native\_credit\_debit      |
    | ethereum.assets.eth\_token\_transfers                                                           | ethereum.assets.native\_token\_transfers   |
    | ethereum.assets.eth\_and\_erc20\_balances\_latest, ethereum.assets.eth\_erc20\_balances\_latest | ethereum.assets.fungible\_balances\_latest |
    | ethereum.assets.eth\_and\_erc20\_balances, ethereum.assets.eth\_erc20\_balances                 | ethereum.assets.fungible\_balances         |
    | ethereum.assets.eth\_and\_erc20\_token\_transfers                                               | ethereum.assets.fungible\_token\_transfers |
    | ethereum.assets.unhydrated\_fungible\_balances                                                  | ethereum.assets.fungible\_balances         |
  </Accordion>

  <Accordion title="Mode Assets">
    | Legacy Table                             | New Table                              |
    | ---------------------------------------- | -------------------------------------- |
    | mode.assets.eth\_token\_transfers        | mode.assets.native\_token\_transfers   |
    | mode.assets.eth\_erc20\_token\_transfers | mode.assets.fungible\_token\_transfers |
  </Accordion>

  <Accordion title="Optimism Assets">
    | Legacy Table                                   | New Table                                  |
    | ---------------------------------------------- | ------------------------------------------ |
    | optimism.assets.eth\_balances                  | optimism.assets.native\_balances           |
    | optimism.assets.eth\_credit\_debit             | optimism.assets.native\_credit\_debit      |
    | optimism.assets.eth\_token\_transfers          | optimism.assets.native\_token\_transfers   |
    | optimism.assets.eth\_erc20\_balances           | optimism.assets.fungible\_balances         |
    | optimism.assets.eth\_erc20\_token\_transfers   | optimism.assets.fungible\_token\_transfers |
    | optimism.assets.unhydrated\_fungible\_balances | optimism.assets.fungible\_balances         |
  </Accordion>

  <Accordion title="Polygon Assets">
    | Legacy Table                                       | New Table                                 |
    | -------------------------------------------------- | ----------------------------------------- |
    | polygon.assets.matic\_balances\_latest             | polygon.assets.native\_balances\_latest   |
    | polygon.assets.matic\_balances                     | polygon.assets.native\_balances           |
    | polygon.assets.matic\_credit\_debit                | polygon.assets.native\_credit\_debit      |
    | polygon.assets.matic\_token\_transfers             | polygon.assets.native\_token\_transfers   |
    | polygon.assets.pol\_balances\_latest               | polygon.assets.native\_balances\_latest   |
    | polygon.assets.pol\_balances                       | polygon.assets.native\_balances           |
    | polygon.assets.pol\_credit\_debit                  | polygon.assets.native\_credit\_debit      |
    | polygon.assets.pol\_token\_transfers               | polygon.assets.native\_token\_transfers   |
    | polygon.assets.matic\_and\_erc20\_balances\_latest | polygon.assets.fungible\_balances\_latest |
    | polygon.assets.matic\_and\_erc20\_balances         | polygon.assets.fungible\_balances         |
    | polygon.assets.matic\_and\_erc20\_token\_transfers | polygon.assets.fungible\_token\_transfers |
    | polygon.assets.unhydrated\_fungible\_balances      | polygon.assets.fungible\_balances         |
  </Accordion>

  <Accordion title="Polygon zkEVM Assets">
    | Legacy Table                                       | New Table                                        |
    | -------------------------------------------------- | ------------------------------------------------ |
    | polygon\_zkevm.assets.eth\_token\_transfers        | polygon\_zkevm.assets.native\_token\_transfers   |
    | polygon\_zkevm.assets.eth\_erc20\_token\_transfers | polygon\_zkevm.assets.fungible\_token\_transfers |
  </Accordion>

  <Accordion title="Scroll Assets">
    | Legacy Table                               | New Table                                |
    | ------------------------------------------ | ---------------------------------------- |
    | scroll.assets.eth\_token\_transfers        | scroll.assets.native\_token\_transfers   |
    | scroll.assets.eth\_erc20\_token\_transfers | scroll.assets.fungible\_token\_transfers |
  </Accordion>

  <Accordion title="Zora Assets">
    | Legacy Table                             | New Table                              |
    | ---------------------------------------- | -------------------------------------- |
    | zora.assets.eth\_token\_transfers        | zora.assets.native\_token\_transfers   |
    | zora.assets.eth\_erc20\_token\_transfers | zora.assets.fungible\_token\_transfers |
  </Accordion>

  <Accordion title="Common Prices">
    | Legacy Table                              | New Table            |
    | ----------------------------------------- | -------------------- |
    | common.prices.token\_prices\_hourly\_easy | common.prices.hourly |
  </Accordion>

  <Accordion title="DEX Token Prices">
    | Legacy Table                               | New Table                          |
    | ------------------------------------------ | ---------------------------------- |
    | ethereum.prices.dex\_token\_prices\_hourly | ethereum.dex.token\_prices\_hourly |
    | arbitrum.prices.dex\_token\_prices\_hourly | arbitrum.dex.token\_prices\_hourly |
    | base.prices.dex\_token\_prices\_hourly     | base.dex.token\_prices\_hourly     |
    | polygon.prices.dex\_token\_prices\_hourly  | polygon.dex.token\_prices\_hourly  |
  </Accordion>
</AccordionGroup>

## Schema Changes & Column Mappings

### Fungible Token Transfers

<Info>
  **Important**: The `ASSETS.FUNGIBLE_TOKEN_TRANSFERS` table contains **both native and ERC20 token transfers**, same as the legacy tables it replaces. Use the `token_type` column to filter: `NATIVE` for native transfers, `ERC20` for ERC20 transfers.
</Info>

When migrating from legacy ERC20 token transfer tables (e.g., `ASSETS.ETH_ERC20_TOKEN_TRANSFERS`) to the new `ASSETS.FUNGIBLE_TOKEN_TRANSFERS` schema, the following changes apply:

#### Column Renames

| Legacy Column       | New Column      | Description                |
| ------------------- | --------------- | -------------------------- |
| `erc20_log_index`   | `log_index`     | Simplified for consistency |
| `call_type`         | `eth_call_type` | Clarifies EVM call context |
| `eth_transfer_type` | `transfer_type` | Unified naming             |

#### Value Changes

| Field        | Legacy Value | New Value  | Description                     |
| ------------ | ------------ | ---------- | ------------------------------- |
| `token_type` | `'ETH'`      | `'NATIVE'` | Standardized native token label |

<Note>
  All other columns maintain the same names and types between the legacy and new schemas.
</Note>

### Token Prices

The `token_prices_hourly_easy` table is being deprecated in favor of `common.prices.hourly`.

<Warning>
  The new `hourly` table does **not** provide the same abstraction of token prices across chains. This cross-chain abstraction feature is no longer supported. All other column names and types remain the same.
</Warning>

### Migration Checklist

* **Review the new schema structure** - Review available columns
* **Update your queries** - Replace all references to legacy tables using the mappings above
* **Test your applications** - Run existing queries against new schemas to ensure compatibility
* **Deploy changes** - Update your workflows to use the new schema
* **Validate results** - Verify data accuracy and performance
* **Complete migration by December 18, 2025** - Legacy schemas will be removed after this date

### Key Benefits

The new schemas maintain full coverage with:

* **Unified fungible tables** - native and ERC20 token data combined into single `fungible_*` tables, reducing query complexity
* **Standardized naming** across all chains
* **Consistent chain logic** and data structure
* Maintenance and support of the new schemas

### Support

If you need help with migration or have questions about deprecated schemas:

* Review the recommended alternative schema documentation.
* Reach out to our support team for migration assistance.