canton.core Table: ez_amulet_lock_lifecycle Type: View
What
Description
Comprehensive EZ view showing the complete lifecycle of locked amulets from initial lock through unlock or expiration. Joins lock and unlock events to provide a full picture of staking activity including durations, status, and outcomes.Key Use Cases
- Analyzing complete amulet locking/staking patterns
- Calculating average lock durations
- Identifying locks that expired vs were actively unlocked
- Tracking which locks were unlocked after expiry
- Understanding staking behavior and timing
- Monitoring currently active locks
Important Relationships
- Combines
core__fact_amulet_locksandcore__fact_amulet_unlocksvia locked_amulet_contract_id - Links to validators and staking through amulet_owner and lock_holders
Commonly-used Fields
locked_amulet_contract_id: Unique identifier for the locked amuletamulet_owner: Party who owns the locked amuletlock_status: Current status (locked, unlocked, or expired)locked_at: When the lock was createdunlocked_at: When it was unlocked (NULL if still locked)locked_amount: Amount lockeddays_locked_before_unlock: Duration for completed locksdays_locked_current: Duration for active lockswas_unlocked_after_expiry: Whether unlock happened after expiration time
Columns
| Column Name | Data Type | Description |
|---|---|---|
| LOCKED_AMULET_CONTRACT_ID | TEXT | LOCKED_AMULET_CONTRACT_ID column |
| AMULET_OWNER | TEXT | AMULET_OWNER column |
| LOCK_HOLDERS | VARIANT | LOCK_HOLDERS column |
| LOCKED_AT | TIMESTAMP_NTZ | LOCKED_AT column |
| LOCK_EXPIRES_AT | TIMESTAMP_NTZ | LOCK_EXPIRES_AT column |
| UNLOCKED_AT | TIMESTAMP_NTZ | UNLOCKED_AT column |
| LOCKED_AMOUNT | NUMBER | LOCKED_AMOUNT column |
| UNLOCKED_AMOUNT | NUMBER | UNLOCKED_AMOUNT column |
| AMOUNT_CREATED_AT_ROUND | NUMBER | AMOUNT_CREATED_AT_ROUND column |
| RATE_PER_ROUND | NUMBER | RATE_PER_ROUND column |
| UNLOCK_ACTION | TEXT | UNLOCK_ACTION column |
| UNLOCK_REASON | TEXT | UNLOCK_REASON column |
| TX_KIND | TEXT | TX_KIND column |
| UNLOCK_AMULET_PRICE | NUMBER | UNLOCK_AMULET_PRICE column |
| UNLOCK_ROUND_NUMBER | NUMBER | UNLOCK_ROUND_NUMBER column |
| CREATED_AMULET_CONTRACT_ID | TEXT | CREATED_AMULET_CONTRACT_ID column |
| LOCK_EVENT_ID | TEXT | LOCK_EVENT_ID column |
| UNLOCK_EVENT_ID | TEXT | UNLOCK_EVENT_ID column |
| LOCK_STATUS | TEXT | LOCK_STATUS column |
| DAYS_LOCKED_BEFORE_UNLOCK | NUMBER | DAYS_LOCKED_BEFORE_UNLOCK column |
| DAYS_LOCKED_CURRENT | NUMBER | DAYS_LOCKED_CURRENT column |
| WAS_UNLOCKED_AFTER_EXPIRY | BOOLEAN | WAS_UNLOCKED_AFTER_EXPIRY column |
| MOST_RECENT_ACTIVITY | TIMESTAMP_NTZ | MOST_RECENT_ACTIVITY column |
| CREATED_AT | TIMESTAMP_NTZ | CREATED_AT column |
| SIGNATORIES | VARIANT | SIGNATORIES column |
| OBSERVERS | VARIANT | OBSERVERS column |
| EZ_AMULET_LOCK_LIFECYCLE_ID | TEXT | EZ_AMULET_LOCK_LIFECYCLE_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |