bridge_revenue_to_purchased_contingent


Description

Bridge table linking revenue transactions to purchased contingents (day passes, class packs, etc.). Handles many-to-many relationships where one sale position may create multiple contingents (e.g., bundle products, family packs). Use this table to analyze revenue by specific purchased contingent while avoiding grain issues and revenue duplication.

Example use cases: - “Show revenue generated from day pass sales with their utilization rates” - “Analyze which purchased contingents contribute most to revenue” - “Track revenue for bundle products that create multiple contingents”

Columns

Column Type Size Nulls Auto Default Children Parents Comments
revenue_to_purchased_contingent_id varchar 256 null

Surrogate primary key generated from revenue_id and purchased_contingent_id.
revenue_id int8 19 √ null
fct_revenue.revenue_id bridge_revenue_to_purchased_contingent_revenue_id_fkey R

The revenue transaction that includes the sale of this purchased contingent.
purchased_contingent_id int8 19 √ null
dim_purchased_contingent.purchased_contingent_id Implied Constraint R

The purchased contingent (day pass, class pack, etc.) created by this revenue transaction.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).

Relationships

Close relationships within degrees of separation