thorchain.core Table: fact_instantiate_events Type: Base Table
What
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 | _INSERTED_TIMESTAMP column |
| _AUDIT_RUN_ID | TEXT | _AUDIT_RUN_ID column |
| 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. |