dim_customer


Description

A customer is a person who signed up to a studio owned by you or your franchise.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
customer_id int8 19 null
bridge_customer_to_customer_code.customer_id bridge_customer_to_customer_code_customer_id_fkey R
dim_customer_communication_consent.customer_id Implied Constraint R
dim_customer_custom_field.customer_id dim_customer_custom_field_customer_id_fkey R
fct_checkin.customer_id fct_checkin_customer_id_fkey R
fct_class_event.customer_id fct_class_event_customer_id_fkey R
fct_contract.customer_id fct_contract_customer_id_fkey R
fct_contract_cancellation.customer_id fct_contract_cancellation_customer_id_fkey R
fct_contract_price_history.customer_id fct_contract_price_history_customer_id_fkey R
fct_contract_term_dates.customer_id fct_contract_term_dates_customer_id_fkey R
fct_customer_appointment.customer_id fct_customer_appointment_customer_id_fkey R
fct_customer_studio_history.customer_id fct_customer_studio_history_customer_id_fkey R
fct_idle_period.customer_id fct_idle_period_customer_id_fkey R
fct_lead_lifetime.customer_id fct_lead_lifetime_customer_id_fkey R
fct_payment_run.customer_id fct_payment_run_customer_id_fkey R
fct_revenue.customer_id Implied Constraint R
fct_revenue_cash_based.customer_id Implied Constraint R
fct_service_usage.customer_id fct_service_usage_customer_id_fkey R

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

More human-readable identifier key to identify the person. Formatted as studioprefix-number (eg AB-123). Freed up (set null) on archived customers to redistribute.
imported_customer_number varchar 256 √ null

The customer number as it was set in a previous system the customer was imported from. Only set if it was specifically required in the import-process.
third_party_id varchar 256 √ null

A unique identifier of the person in a third-party system. This is used to link the person to a third-party system, like a CRM or ERP system.
customer_status varchar 256 √ null

The current (business) relation of the person to the studio.

One of: * PROSPECT: The person entered contact information but has no valid contract (yet). * MEMBER: The person has a valid contract which end_date is in the future. * FORMER_MEMBER: The person had a valid contract which end_date is in the past.
firstname varchar 256 √ null

The personal name given to the person at birth
second_firstname varchar 256 √ null

The personal name given to the person at birth
lastname varchar 256 √ null

The family name of the person
second_lastname varchar 256 √ null

The family name of the person
street varchar 256 √ null

The name of the street the person lives in
house_number varchar 256 √ null

The unique identifier of a building in a street the person lives in
zip varchar 256 √ null

The ZIP-Code (postal code) of the place the person lives in
city varchar 256 √ null

The name of the settlement the person lives in
country varchar 256 √ null

The 2-letter ISO 3166 abbreviation of the country the person lives in
tel_private varchar 256 √ null

The private phone number of the person
tel_private_mobile varchar 256 √ null

The private mobile phone number of the person
tel_business varchar 256 √ null

The at-work phone number of the person
tel_business_mobile varchar 256 √ null

The at-work mobile phone number of the person
email varchar 256 √ null

The email address of the person
email_verification_status varchar 256 √ null

The current state of verification of the persons email address.

One of: * INITIAL: No verification email was sent yet. * PENDING: The verification email was sent and is waiting for action of the recipient. * VERIFIED: The recipient successfully verified the email address by clicking the verification link. * UNVERIFIED: No email address is set or the recipient did not react on the verification email for 24 hours.
gender varchar 256 √ null

The sex the person identifies with
date_of_birth date 13 √ null

The date at which the person was born
place_of_birth varchar 256 √ null

The name of the city the person was born
country_of_birth varchar 256 √ null

The name of the nation the person was born
deceased bool 1 √ null

Whether the person died
archived bool 1 √ null

Permanently removed but kept for historic relations
created_date date 13 √ null

Date when the customer was added to the current Systems database
locale varchar 256 √ null

The language of a customer represented by its ISO-639 and ISO-3166 Code
customer_origin varchar 256 √ null
Through which system the customer was created.
  • WEBCLIENT: Customer created via System website by an employee.
  • CONNECT_API: Customer created via the public Systems API (eg tenant website)
  • EXTERNAL: Customer created via Partner Integration.
  • SALES_TOOL: Customer created via “Sales Tool” a special part of the Systems website optimized for tablets to easily create contracts together with the (to-be) member.
  • LEGACY_MYSPORTS: Customer created via Mysports/Branded App or mysports.com (only set for customers created as leads before 2023-08).
  • MYSPORTS_APP: Customer created via Mysports/Branded App.
  • MYSPORTS_WEB: Customer created via mysports.com
  • ONLINE_CHECKOUT_PAGE: Customer created via Studio Pages feature (See Settings > Websites > Studio pages)
  • LEGACY_WEB: Customer created via CONNECT_API, ONLINE_CHECKOUT_PAGE or similar Web sources of the System (only set for customers created as leads before 2023-08)
  • IMPORT-*: Customer was imported from another system or from a file and other origins can’t be determined.
  • UNKNOWN: The origin can not or no longer be determined. (Often the case for customers created as leads before 2023-08)
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