thorchain.core Table: fact_instantiate_events Type: Base Table
Comprehensive fact table tracking smart contract instantiation events on THORchain blockchain. This
table captures detailed information about new smart contract deployments including contract
addresses, admin addresses, code IDs, senders, labels, initialization messages, and funding details.
Essential for monitoring THORchain ecosystem development, tracking contract creation patterns,
analyzing developer activity, and understanding the growth and evolution of the smart contract
landscape. Each record represents a unique contract instantiation event with complete deployment
metadata for thorough blockchain development analysis and ecosystem monitoring.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| FACT_INSTANTIATE_EVENTS_ID | TEXT | The surrogate key for the table. Will be unique and is used as a foreign key in other tables |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | Timestamp of block minting(without a timezone) |
| DIM_BLOCK_ID | TEXT | FK to DIM_BLOCK table |
| TX_ID | TEXT | The unique transaction id |
| CONTRACT_ADDRESS | TEXT | The contract address |
| ADMIN_ADDRESS | TEXT | The admin address |
| CODE_ID | NUMBER | The code ID |
| SENDER | TEXT | The sending address for this event |
| LABEL | TEXT | The label |
| MSG | VARIANT | The message |
| FUNDS | TEXT | The funds |
| EVENT_ID | NUMBER | The primary key for the table. |
| _INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| _AUDIT_RUN_ID | TEXT | |
| 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. |