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

​
Description

Tracks IssuingMiningRound contract creation events, representing when new mining rounds are opened and become active. Contains detailed per-coupon-type issuance rates and round timing information.

​
Key Use Cases

  • Monitoring mining round lifecycle (opening phase)
  • Understanding issuance rates for different reward types
  • Tracking round timing (opens_at, target_closes_at)
  • Analyzing reward distribution economics per round

​
Important Relationships

  • Counterpart to core__fact_round_closes (same round_number, different phases)
  • Links to reward coupon creation events via round_number
  • DSO party references governance

​
Commonly-used Fields

  • round_number: Sequential round identifier
  • opens_at: When the round opens
  • target_closes_at: Target closing time
  • issuance_per_featured_app_coupon: Issuance rate for featured apps
  • issuance_per_unfeatured_app_coupon: Issuance rate for unfeatured apps
  • issuance_per_validator_coupon: Issuance rate for validators
  • issuance_per_sv_coupon: Issuance rate for super validators
  • dso_party: The DSO party managing the round

​
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.
ROUND_NUMBERTEXTSequential number identifying a mining round in the Canton network.
OPENS_ATTEXTTimestamp when a mining round opens.
TARGET_CLOSES_ATTEXTTarget timestamp for when a mining round should close.
ISSUANCE_PER_FEATURED_APP_COUPONTEXTAmount of amulets to issue per featured app reward coupon in this round.
ISSUANCE_PER_UNFEATURED_APP_COUPONTEXTAmount of amulets to issue per unfeatured app reward coupon in this round.
ISSUANCE_PER_VALIDATOR_COUPONTEXTAmount of amulets to issue per validator reward coupon in this round.
ISSUANCE_PER_SV_COUPONTEXTAmount of amulets to issue per super validator reward coupon in this round.
ISSUANCE_PER_VALIDATOR_FAUCET_COUPONTEXTAmount of amulets to issue per validator faucet coupon in this round (optional/may be NULL).
DSO_PARTYTEXTParty identifier for the DSO (Digital Synchronizer Operator) that manages network governance and operations.
EVENT_TYPETEXTType of event: ‘created_event’ for contract creation or ‘exercised_event’ for method execution on existing contracts.
CONTRACT_IDTEXTUnique identifier for the contract being created or exercised in this event.
PACKAGE_NAMETEXTThe Canton package name containing the contract template.
TEMPLATE_IDTEXTThe template/type of the contract, including package information. Format: ‘package_id:ModuleName:ContractType’
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.
EVENT_JSONTEXTFull JSON object containing all event data. Useful for detailed analysis and accessing fields not explicitly extracted.
FACT_OPEN_ROUND_IDTEXTSurrogate key generated from round_number
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).