canton.core Table: fact_round_opens Type: Base Table
What
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 identifieropens_at: When the round openstarget_closes_at: Target closing timeissuance_per_featured_app_coupon: Issuance rate for featured appsissuance_per_unfeatured_app_coupon: Issuance rate for unfeatured appsissuance_per_validator_coupon: Issuance rate for validatorsissuance_per_sv_coupon: Issuance rate for super validatorsdso_party: The DSO party managing the round
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 |
| ROUND_NUMBER | NUMBER | ROUND_NUMBER column |
| OPENS_AT | TIMESTAMP_NTZ | OPENS_AT column |
| TARGET_CLOSES_AT | TIMESTAMP_NTZ | TARGET_CLOSES_AT column |
| ISSUANCE_PER_FEATURED_APP_COUPON | NUMBER | ISSUANCE_PER_FEATURED_APP_COUPON column |
| ISSUANCE_PER_UNFEATURED_APP_COUPON | NUMBER | ISSUANCE_PER_UNFEATURED_APP_COUPON column |
| ISSUANCE_PER_VALIDATOR_COUPON | NUMBER | ISSUANCE_PER_VALIDATOR_COUPON column |
| ISSUANCE_PER_SV_COUPON | NUMBER | ISSUANCE_PER_SV_COUPON column |
| ISSUANCE_PER_VALIDATOR_FAUCET_COUPON | NUMBER | ISSUANCE_PER_VALIDATOR_FAUCET_COUPON column |
| DSO_PARTY | TEXT | DSO_PARTY column |
| CONTRACT_ID | TEXT | CONTRACT_ID column |
| TEMPLATE_ID | TEXT | TEMPLATE_ID column |
| CREATED_AT | TIMESTAMP_NTZ | CREATED_AT column |
| SIGNATORIES | VARIANT | SIGNATORIES column |
| OBSERVERS | VARIANT | OBSERVERS column |
| EVENT_JSON | VARIANT | EVENT_JSON column |
| FACT_OPEN_ROUND_ID | TEXT | FACT_OPEN_ROUND_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |