canton.core Table: fact_amulet_locks Type: Base Table
What
Description
Tracks when amulets are locked/staked by creating LockedAmulet contracts. Locking amulets allows holders to stake their tokens, typically for validator operations or other protocol functions.Key Use Cases
- Monitoring staking activity and locked amounts
- Tracking lock expiration times
- Analyzing lock holder patterns
- Understanding rate per round for locked amulets
Important Relationships
- Links to
core__fact_amulet_unlocksvia amulet_owner and contract_id patterns - Related to validator operations through lock_holders
Commonly-used Fields
locked_amount: Initial amount of amulet being lockedamulet_owner: The party who owns the locked amuletlock_expires_at: When the lock expireslock_holders: Parties who hold the lockrate_per_round: Rate of fee accrual per roundamount_created_at_round: Round when the amount was created
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 |
| LOCKED_AMOUNT | NUMBER | LOCKED_AMOUNT column |
| AMOUNT_CREATED_AT_ROUND | NUMBER | AMOUNT_CREATED_AT_ROUND column |
| RATE_PER_ROUND | NUMBER | RATE_PER_ROUND column |
| AMULET_OWNER | TEXT | AMULET_OWNER column |
| LOCK_DETAILS | VARIANT | LOCK_DETAILS column |
| LOCK_EXPIRES_AT | TIMESTAMP_NTZ | LOCK_EXPIRES_AT column |
| LOCK_HOLDERS | VARIANT | LOCK_HOLDERS column |
| LOCKED_AMULET_CONTRACT_ID | TEXT | LOCKED_AMULET_CONTRACT_ID column |
| CREATED_AT | TIMESTAMP_NTZ | CREATED_AT column |
| SIGNATORIES | VARIANT | SIGNATORIES column |
| OBSERVERS | VARIANT | OBSERVERS column |
| PACKAGE_NAME | TEXT | PACKAGE_NAME column |
| TEMPLATE_ID | TEXT | TEMPLATE_ID column |
| FACT_LOCK_ID | TEXT | FACT_LOCK_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |