bridge_rate_bundle_term_availability


Description

Bridge table listing which organization units can sell each rate bundle term, driven by the bundle whitelist and active bundle group configuration.

Columns

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

The primary key of this table. Surrogate key built from the bundle term and organization unit.
rate_bundle_term_id int8 19 √ null
dim_rate_bundle_term.rate_bundle_term_id Implied Constraint R

The rate bundle term available in the organization unit.
organization_unit_id int8 19 √ null

The organization unit (gym) where the bundle term is available.
is_active bool 1 √ null

Whether the bundle term is active for the organization unit based on the active rate bundle group configuration.
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