dim_organization_unit


Description

A gym. The physical location at which people go to work out. But also the abstract entity to which customers sign up to.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
organization_unit_id int8 19 null
bridge_company_to_organization_unit.organization_unit_id bridge_company_to_organization_unit_organization_unit_id_fkey R
bridge_organization_unit_to_organization_unit_code.organization_unit_id Implied Constraint R
dim_closing_hours.organization_unit_id dim_closing_hours_organization_unit_id_fkey R
dim_customer_communication_consent.organization_unit_id dim_customer_communication_consent_organization_unit_id_fkey R
dim_device.active dim_device_active_fkey R
dim_employee.working_time_model dim_employee_working_time_model_fkey R
dim_idle_period_property.organization_unit_id dim_idle_period_property_organization_unit_id_fkey R
dim_opening_hours.organization_unit_id Implied Constraint R
fct_checkin.customer_organization_unit_id fct_checkin_customer_organization_unit_id_fkey R
fct_checkin.organization_unit_id fct_checkin_organization_unit_id_fkey R
fct_class_appointment.organization_unit_id fct_class_appointment_organization_unit_id_fkey R
fct_class_event.organization_unit_id fct_class_event_organization_unit_id_fkey R
fct_contract.organization_unit_id fct_contract_organization_unit_id_fkey R
fct_contract_price_history.organization_unit_id fct_contract_price_history_organization_unit_id_fkey R
fct_customer_appointment.organization_unit_id fct_customer_appointment_organization_unit_id_fkey R
fct_customer_studio_history.organization_unit_id fct_customer_studio_history_organization_unit_id_fkey R
fct_employee_access.organization_unit_id fct_employee_access_organization_unit_id_fkey R
fct_idle_period.organization_unit_id fct_idle_period_organization_unit_id_fkey R
fct_lead_lifetime.organization_unit_id fct_lead_lifetime_organization_unit_id_fkey R
fct_payment_run.organization_unit_id fct_payment_run_organization_unit_id_fkey R
fct_revenue.organization_unit_id Implied Constraint R
fct_revenue_cash_based.organization_unit_id Implied Constraint R
fct_service_usage.organization_unit_id fct_service_usage_organization_unit_id_fkey R
fct_trainer_appointment.organization_unit_id fct_trainer_appointment_organization_unit_id_fkey R
fct_trainer_class_appointments.organization_unit_id fct_trainer_class_appointments_organization_unit_id_fkey R

The primary key of this table. System column calculated by the source System.
studio_prefix varchar 256 √ null

A unique identifier of the gym that is used as a prefix for the dim_customer.customer_number of it’s customers.
name varchar 256 √ null

The name of the gym.
street varchar 256 √ null

The street name of the gym’s address.
house_number varchar 256 √ null

The house number of the gym’s address.
zip varchar 256 √ null

The postal code of the gym’s address.
city varchar 256 √ null

The city of the gym’s address.
country varchar 256 √ null

The country of the gym’s address.
latitude float8 17,17 √ null

The latitude coordinate of the gym’s location in decimal degrees (WGS84).
longitude float8 17,17 √ null

The longitude coordinate of the gym’s location in decimal degrees (WGS84).
tax_region varchar 256 √ null

The 2-letter ISO 3166 abbreviation of the country the gym is located at.
timezone varchar 256 √ null

The name of the timezone the gym is located at. (Eg. Europe/Berlin)
archived bool 1 √ null

Permanently removed but kept for historic relations.
disabled bool 1 √ null

Temporarily disabled, preventing new customers from signing up to this gym.
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