Skip to main content
Schema: canton.core Table: fact_amulet_locks Type: Incremental

​
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_unlocks via amulet_owner and contract_id patterns
  • Related to validator operations through lock_holders

​
Commonly-used Fields

  • locked_amount: Initial amount of amulet being locked
  • amulet_owner: The party who owns the locked amulet
  • lock_expires_at: When the lock expires
  • lock_holders: Parties who hold the lock
  • rate_per_round: Rate of fee accrual per round
  • amount_created_at_round: Round when the amount was created

​
Columns

Column NameData TypeDescription
UPDATE_IDTEXTUnique identifier for the Canton update/transaction. An update contains one or more events and represents an atomic change to the blockchain state.
MIGRATION_IDTEXTCanton migration identifier. Used to track different phases or migrations in the Canton network’s evolution.
RECORD_TIMETEXTTimestamp when the update was recorded in the system.
EFFECTIVE_ATTEXTTimestamp when the event or update became effective on the blockchain. This is the canonical time for ordering and analyzing blockchain events.
EVENT_IDTEXTUnique identifier for the event within the Canton blockchain.
EVENT_INDEXTEXTOrdering index of events within an update. Events within the same update are sequentially numbered starting from 0.
LOCKED_AMOUNTTEXTInitial amount of amulet being locked/staked.
AMOUNT_CREATED_AT_ROUNDTEXTRound number when an amulet amount was originally created.
RATE_PER_ROUNDTEXTRate at which fees or rewards accrue per mining round.
AMULET_OWNERTEXTParty identifier for the owner of an amulet (locked or unlocked).
LOCK_DETAILSTEXTJSON object containing full lock configuration
LOCK_EXPIRES_ATTEXTTimestamp when a lock expires and the amulet can be unlocked.
LOCK_HOLDERSTEXTArray of party identifiers who hold rights to a locked amulet.
LOCKED_AMULET_CONTRACT_IDTEXTContract ID for a LockedAmulet contract.
CREATED_ATTEXTTimestamp when the contract was created.
SIGNATORIESTEXTArray of party identifiers who are signatories to the contract.
OBSERVERSTEXTArray of party identifiers who can observe the contract but are not signatories.
PACKAGE_NAMETEXTThe Canton package name containing the contract template.
TEMPLATE_IDTEXTThe template/type of the contract, including package information. Format: ‘package_id:ModuleName:ContractType’
FACT_LOCK_IDTEXTSurrogate key generated from event_id
INSERTED_TIMESTAMPTEXTTimestamp when the record was inserted into this table (Snowflake SYSDATE).
MODIFIED_TIMESTAMPTEXTTimestamp when the record was last modified in this table (Snowflake SYSDATE).