crosschain.core Table: dim_evm_event_abis Type: View
What
This table contains the individual event abis for each all contracts that we have ABIs for. Proxies are rolled up to their implementation.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCKCHAIN | TEXT | The blockchain that the event abi is for. |
| PARENT_CONTRACT_ADDRESS | TEXT | The address of the contract that the event abi is for. |
| EVENT_NAME | TEXT | The name of the event. |
| ABI | VARIANT | The abi of the event. |
| SIMPLE_EVENT_NAME | TEXT | The name of the event along with its parameters. |
| EVENT_SIGNATURE | TEXT | The keccak256 signature of the simple event name. This can be used to filter for events in the logs table on topics[0]. |
| START_BLOCK | NUMBER | The block number of the creation of the contract containing the event. This could be from a proxy or an implementation. |
| END_BLOCK | NUMBER | The block number before a similar event was created in the contract. This could be from a proxy or an implementation. |
| 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_EVM_EVENT_ABIS_ID | TEXT | The unique identifier for each row in the table. |