canton.core Table: fact_amulet_unlocks Type: Base Table
What
Description
Tracks unlocking/unstaking of locked amulets through exercise events. Joins to child Amulet created events to capture details of the newly created unlocked amulet.Key Use Cases
- Monitoring unstaking activity
- Tracking unlock reasons and transaction types
- Analyzing unlocked amounts and their destinations
- Understanding validator unstaking patterns
Important Relationships
- Counterpart to
core__fact_amulet_locks - Joins parent unlock event to child Amulet creation event
- Links to rounds via
round_numberandopen_round_cid
Commonly-used Fields
unlock_action: Either ‘unlock’ or ‘expire_lock’unlocked_amount: Amount being unlockedowner: Party receiving the unlocked amuletamulet_price: USD price at time of unlockround_number: Round in which unlock occurredunlock_reason: Metadata describing why unlock happenedlocked_amulet_contract_id: Original locked contractcreated_amulet_contract_id: New unlocked amulet contract
Columns
| Column Name | Data Type | Description |
|---|---|---|
| UPDATE_ID | TEXT | UPDATE_ID column |
| MIGRATION_ID | NUMBER | MIGRATION_ID column |
| RECORD_TIME | TIMESTAMP_NTZ | RECORD_TIME column |
| EFFECTIVE_AT | TIMESTAMP_NTZ | EFFECTIVE_AT column |
| EVENT_ID | TEXT | EVENT_ID column |
| EVENT_INDEX | NUMBER | EVENT_INDEX column |
| CHOICE | TEXT | CHOICE column |
| ACTING_PARTIES | VARIANT | ACTING_PARTIES column |
| UNLOCK_ACTION | TEXT | UNLOCK_ACTION column |
| OPEN_ROUND_CID | TEXT | OPEN_ROUND_CID column |
| UNLOCKED_AMULET_CID | TEXT | UNLOCKED_AMULET_CID column |
| AMULET_PRICE | NUMBER | AMULET_PRICE column |
| ROUND_NUMBER | NUMBER | ROUND_NUMBER column |
| UNLOCK_REASON | TEXT | UNLOCK_REASON column |
| TX_KIND | TEXT | TX_KIND column |
| UNLOCKED_AMOUNT | NUMBER | UNLOCKED_AMOUNT column |
| CREATED_AT_ROUND | NUMBER | CREATED_AT_ROUND column |
| RATE_PER_ROUND | NUMBER | RATE_PER_ROUND column |
| OWNER | TEXT | OWNER column |
| AMULET_CREATED_AT | TIMESTAMP_NTZ | AMULET_CREATED_AT column |
| EVENT_TYPE | TEXT | EVENT_TYPE column |
| LOCKED_AMULET_CONTRACT_ID | TEXT | LOCKED_AMULET_CONTRACT_ID column |
| CONSUMING | BOOLEAN | CONSUMING column |
| CREATED_AMULET_CONTRACT_ID | TEXT | CREATED_AMULET_CONTRACT_ID column |
| FACT_AMULET_UNLOCKS_ID | TEXT | FACT_AMULET_UNLOCKS_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |