Table Details
| Property | Value |
|---|---|
| Table Name | stacks.raw.events |
| Table Status | Production-Ready |
| Unique Key | tx_id, event_index |
| Clustering Key(s) | to_date("burn_block_time") |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| block_hash | VARCHAR(16777216) | The hash of the block containing the event. |
| block_height | NUMBER(38,0) | The height of the block containing the event. |
| burn_block_time | TIMESTAMP_NTZ(9) | Timestamp when the corresponding burn block was mined. |
| event_index | NUMBER(38,0) | Index of the event within the transaction. |
| event_type | VARCHAR(16777216) | Type of the event (e.g., smart_contract_log, stx_lock, fungible_asset). |
| tx_id | VARCHAR(16777216) | The unique identifier or hash of the transaction associated with the event. |
| event_contents | VARIANT | Contents of the event. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update. |