Database Properties
Database Type: Redshift - 8.0.2
Schema preview
Preview PerfectGym Next Enterprise Data Warehouse
These are the docs for the
Real-Time [preview]Data Warehouse schema. To see the docs for the current stable schema, please refer to the Real-Time [Current] schema docs.
This read-only schema provides a view to see and validate upcoming changes to the PerfectGym Next Data Warehouse schema before they are released to production. It contains new tables, columns or other changes that are not yet part of the stable schema.
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| dim_rate_bundle | 3 | 0 | 7 | Table | Rate bundle (offer) header that defines which contract package can be sold and the contract timing rules tied to it. |
| dim_device | 0 | 0 | 6 | Table | A device connected to the system, which enables registering customers using certain areas (the whole gym, the gym sauna) or machines (eg a massage bed) of a gym. |
| dim_rate_term_payment_frequency_age_based_adjustment | 0 | 0 | 7 | Table | Age-based price adjustments for payment frequencies. |
| dim_rate_bundle_term | 1 | 1 | 9 | Table | Payment-term options for a rate bundle, such as monthly or term-based variants, including the payment frequency used to charge customers. |
| dim_rate_term_payment_frequency_month_days | 0 | 0 | 5 | Table | Payment frequency pricing that varies by specific days of the month. |
| dim_rate_term_payment_frequency | 0 | 0 | 10 | Table | Payment frequency options available for rate terms, including price, cadence, and calculation settings. |
| fct_rate_bundle_price | 0 | 1 | 17 | Table | Reporting-ready bundle prices with a default organization unit row, age bands (defaulting to 0-199), and optional term or month-day windows. final_price already applies organization unit and age adjustments. |
| dim_rate_term_configuration | 1 | 0 | 20 | Table | Configuration of contract terms, extensions, cancellations and idle periods for a rate. This table details the rules governing the lifecycle of a contract associated with a specific rate, including initial duration, renewal policies, cancellation notice periods, and allowances for pausing the contract (idle periods). |
| dim_rate_term_payment_frequency_adjustment | 0 | 0 | 5 | Table | Price adjustments for payment frequencies, optionally scoped to a specific organization unit. |
| dim_date | 0 | 0 | 16 | Table | Date dimension covering years 1900-2099 |
| dim_contract_payment_frequency | 0 | 0 | 7 | Table | Defines how often and how much is paid for an individual contract. |
| dim_campaign | 0 | 0 | 7 | Table | Campaign dimension |
| bridge_rate_bundle_term_availability | 0 | 1 | 5 | Table | Bridge table listing which organization units can sell each rate bundle term, driven by the bundle whitelist and active bundle group configuration. |
| bridge_rate_bundle_to_company | 0 | 1 | 7 | Table | Bridge table linking rate bundles to partner companies for corporate deals, including any cooperation identifier used for that partnership. |
| bridge_rate_bundle_payment_choice | 0 | 1 | 4 | Table | Bridge table listing which payment choices are allowed when selling a rate bundle. |
| dim_rate_term_payment_frequency_term_to_price | 0 | 0 | 6 | Table | Price definitions for payment frequencies based on term length. |