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_organization_unit_to_organization_unit_code.organization_unit_id bridge_organization_unit_to_organization_unit_code_organization_unit_id_fkey 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_opening_hours.organization_unit_id dim_opening_hours_organization_unit_id_fkey 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_cancellation.organization_unit_id fct_contract_cancellation_organization_unit_id_fkey R
fct_contract_price_history.organization_unit_id fct_contract_price_history_organization_unit_id_fkey R
fct_contract_term_dates.organization_unit_id fct_contract_term_dates_organization_unit_id_fkey R
fct_customer_appointment.organization_unit_id fct_customer_appointment_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 fct_revenue_organization_unit_id_fkey R
fct_revenue_cash_based.organization_unit_id fct_revenue_cash_based_organization_unit_id_fkey 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 the gym is located at.
house_number varchar 256 √ null

The unique identifier of the building at the street the gym is located at.
zip varchar 256 √ null

The ZIP-Code (postal code) of the place the gym is located at.
city varchar 256 √ null

The name of the city the gym is located at.
country varchar 256 √ null

The name of the country the gym is located at.
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 history.
disabled bool 1 null

(Temporarily) set to a non-functional state, pausing all activity (eg checkins) on this gym.
last_updated timestamptz 35 √ null

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

Relationships

Close relationships within degrees of separation