Business Glossary

A business-friendly reference for all terminology used in the Magicline Enterprise Data Warehouse. Each term includes a plain-language explanation and analyst notes for writing correct SQL queries.

For the structural conventions behind the schema (fact/dimension/bridge tables, keys, grain), see Modelling & Technical Conventions.

The glossary is organized by business domain:

• Core Entities

  ---

  The foundational who/where: gyms, customers, employees, and corporate partners.

• Memberships, Contracts & Pricing

  ---

  Contracts, rates, contract types, and the pricing toolkit — discounts, vouchers, and campaigns.

• Customer Lifecycle & Sales

  ---

  The prospect → member → former-member journey, plus leads and the sales funnel.

• Pauses & Cancellations

  ---

  Membership freezes (idle periods) and how contracts end — cancellations and churn.

• Revenue, Payments & Invoicing

  ---

  The three revenue perspectives, the revenue-group hierarchy, payment runs, and invoices.

• Operations & Engagement

  ---

  Classes and services, products/POS, check-ins, codes and tags, referrals, consent, and opening hours.