dim_service


Description

A general service (a class, a personal training, the replacement of a member card…), that can be provided to a customer. The service could be included in the customers contract(s), with a limiting contingent (eg when its a Sauna subscription) or be booked individually (eg when its a class).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
service_id int8 19 null
fct_customer_appointment.service_id fct_customer_appointment_service_id_fkey R
fct_service_usage.service_id fct_service_usage_service_id_fkey R
fct_trainer_appointment.service_id fct_trainer_appointment_service_id_fkey R

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

The name of the service
description varchar 256 null

The description of the service. NULLs are filled with UNKNOWN.
category_name varchar 256 null

A common group (both user defined or system-given) this service can be categorized into (eg. functionaltraining, wellness, consulting). NULLs are filled with UNKNOWN.
purchasing_type varchar 256 null

How customers can pay to use this service. One of CONSUMPTION_CREDIT, DIRECT_DEBIT, LATER, FORBIDDEN
free_usage bool 1 null

Whether or not the service is free
studio_access_type varchar 256 null

For who this service is available, such as:* MAIN_STUDIO: service is only provided at the customers home studio (the studio, that’s related to his main contract)* ALL_STUDIOS: service is provided at all studios the customer can access* RESTRICTED_STUDIOS: service is only provided at a specific set of studios to the customer
booking_option_type varchar 256 null

How a service can be booked* USAGE_REQUIRES_CONTINGENT: service can be booked only with a usage of a puchased or inclusive contingent e.g via using a voucher or a specific tariff of the contract that user has* FREE_USAGE: service can be booked without any cost in contingent* DISPLAY_ONLY: used for MySports. Customers are not able to book this class. They can only see when this class will take place
archived bool 1 null

Permanently removed but kept for historic relations.
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