blast.core Table: dim_contracts Type: View
This table contains all the contracts that are deployed on the Blast blockchain along with their
on-chain metadata.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| ADDRESS | TEXT | The address of the contract. |
| SYMBOL | TEXT | The symbol of the contract. |
| NAME | TEXT | The name of the contract. |
| DECIMALS | NUMBER | The number of decimals used to adjust amount for this contract. |
| CREATED_BLOCK_NUMBER | NUMBER | The block number when the contract was created |
| CREATED_BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The block timestamp when the contract was created |
| CREATED_TX_HASH | TEXT | The transaction hash when the contract was created |
| CREATOR_ADDRESS | TEXT | The address of the creator of the contract |
| DIM_CONTRACTS_ID | TEXT | The unique identifier for each row in the table. |
| 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. |