bridge_service_to_organization_unit


Description

Access control mapping that defines which services are available at which gym locations. Services must be explicitly whitelisted for a gym before they can be booked or used there. This enables multi-location businesses to offer different service menus at different facilities (e.g., specialized classes only at flagship locations, or region-specific offerings).

Columns

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

Surrogate primary key.
service_id int8 19 √ null
dim_service.service_id Implied Constraint R

The service that has been authorized for use at the gym location (e.g., Yoga Class, Personal Training, Sauna Access).
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id Implied Constraint R

The gym location where customers can book and use this service. Each service-location pairing must be explicitly configured.
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