Table Details
| Property | Value |
|---|---|
| Table Name | filecoin.raw.deal_events |
| Table Status | Beta 🌱 |
| Unique Key | tipset_timestamp, unique_id |
| Clustering Key(s) | to_date("tipset_timestamp") |
| Search Optimization | deal_id, message_cid |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| tipset_height | NUMBER(38,0) | Filecoin tipset height (block height). A tipset is a set of blocks at the same height that form the canonical chain. |
| tipset_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the Filecoin tipset. |
| event_index | NUMBER(38,0) | Zero-based index of this event within its transaction. The specific semantics depend on the chain — on Aptos this is the event_index within the transaction; on Cosmos this is within the message. |
| message_cid | VARCHAR(16777216) | The CID of the message containing the transfer. |
| message_tipset_index | NUMBER(38,0) | Position of this message within its tipset’s ordered message list |
| emitter | VARCHAR(16777216) | Actor address that emitted this Filecoin built-in actor event |
| reverted | BOOLEAN | True if this message or tipset was reverted due to a chain reorganization |
| event_type | VARCHAR(16777216) | Type or category of the onchain event that produced this record. The specific values depend on the model (e.g. transfer_single / batch_transfer for ERC-1155, deposit / withdraw for bridges). |
| deal_id | NUMBER(38,0) | Unique identifier of the Filecoin storage deal |
| client | VARCHAR(16777216) | Filecoin address of the storage client in this deal |
| provider | VARCHAR(16777216) | Data provider (e.g., ccdata) |
| entries | VARIANT | Array of key-value entries in this Filecoin built-in actor event |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |