crosschain.core Table: dim_contracts Type: View
What
This table contains contract details for contracts deployed on the Ethereum, Optimism, Polygon, BSC, Arbitrum, Avalanche, Osmosis and Solana blockchains.Columns
| Column Name | Data Type | Description |
|---|---|---|
| ADDRESS | TEXT | The unique address of the deployed contract. |
| SYMBOL | TEXT | The symbol used to represent this contract. Please note this is not necessarily unique. |
| NAME | TEXT | The name of the deployed contract. Please note this is not necessarily unique. |
| DECIMALS | NUMBER | The number of decimal places this contract needs adjusted where token values exist. |
| CREATED_BLOCK_NUMBER | NUMBER | CREATED_BLOCK_NUMBER column |
| CREATED_BLOCK_TIMESTAMP | TIMESTAMP_NTZ | CREATED_BLOCK_TIMESTAMP column |
| CREATED_TX_HASH | TEXT | CREATED_TX_HASH column |
| CREATOR_ADDRESS | TEXT | CREATOR_ADDRESS column |
| BLOCKCHAIN | TEXT | The corresponding blockchain for contract details. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |
| DIM_CONTRACTS_ID | TEXT | The unique identifier for each row in the table. |