canton.core Table: fact_app_reward_coupons Type: Base Table
What
Description
Tracks the creation of app reward coupons for application providers. These coupons are created during mining rounds and represent rewards earned by app providers.Key Use Cases
- Analyzing app provider reward distribution
- Tracking featured vs unfeatured app rewards
- Understanding per-round reward allocation
- Monitoring app provider incentive economics
Important Relationships
- Links to rounds via
round_number - Can be joined to
core__fact_round_opensorcore__fact_round_closes - Related to
core__fact_app_rewards(expiration of coupons)
Commonly-used Fields
coupon_amount: The reward amount in this couponapp_provider: The party receiving the rewardbeneficiary: The beneficiary of the couponis_featured_app: Whether this is for a featured applicationround_number: Which mining round this coupon was created in
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 |
| COUPON_AMOUNT | NUMBER | COUPON_AMOUNT column |
| APP_PROVIDER | TEXT | APP_PROVIDER column |
| BENEFICIARY | TEXT | BENEFICIARY column |
| IS_FEATURED_APP | BOOLEAN | IS_FEATURED_APP column |
| ROUND_NUMBER | NUMBER | ROUND_NUMBER column |
| DSO_PARTY | TEXT | DSO_PARTY column |
| EVENT_TYPE | TEXT | EVENT_TYPE column |
| COUPON_CONTRACT_ID | TEXT | COUPON_CONTRACT_ID column |
| PACKAGE_NAME | TEXT | PACKAGE_NAME 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_APP_REWARD_COUPON_ID | TEXT | FACT_APP_REWARD_COUPON_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |