1. Spa & Wellness Management
  2. Data model and import order
Reference

The tables behind Spa & Wellness Management

Spa & Wellness Management ships with 12 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.

Tables
12
Features
6, plus shared settings
Change it
Add fields and tables in Proto

How the model is organised

Treatments and sessions:

Services, Sessions. The treatment menu and scheduled sessions with therapist, times and capacity.

Bookings and check-in:

Bookings, Attendance. Guests' places on sessions and the check-in for each confirmed booking.

Therapists and rooms:

Therapist allocations, treatment rooms. Therapist and room time per booking, and each room's readiness.

Members and packages:

Members, membership plans, member plans. Member records, the packages you sell and each member's enrolment.

Payments:

Payments. Pending, confirmed and refunded payments against bookings.

People and access:

People, Users. Therapists and staff linked to user accounts.

Every table, by feature

Treatments and sessions

3 tablesAbout this feature
  • Services

    Treatment and class services offered by the spa.

  • Sessions

    Scheduled deliveries of a service with a capacity and lifecycle state.

    Linked to Services, People
  • People

    Staff directory of therapists, instructors and coordinators linked to platform users.

    Linked to Users

Bookings and check-in

6 tablesAbout this feature
  • Bookings

    Member reservations against a session, holding one or more places.

    Linked to Members, Sessions
  • Attendance

    Check-in evidence captured when a confirmed booking is delivered.

    Linked to Bookings, People
  • Sessions

    Scheduled deliveries of a service with a capacity and lifecycle state.

    Linked to Services, People
  • Members

    Spa members with membership lifecycle status.

  • Member plans

    A member's enrolment in a membership plan for a validity window.

    Linked to Members, Membership plans
  • Payments

    Receipts and pending charges against member bookings.

    Linked to Members, Bookings

Therapist allocations

4 tablesAbout this feature
  • Therapist allocations

    Therapist and room time reserved for a specific booking.

    Linked to Bookings, People, Treatment rooms
  • Bookings

    Member reservations against a session, holding one or more places.

    Linked to Members, Sessions
  • People

    Staff directory of therapists, instructors and coordinators linked to platform users.

    Linked to Users
  • Treatment rooms

    Room readiness and occupancy records tied to a booking.

    Linked to Bookings

Treatment rooms

3 tablesAbout this feature
  • Treatment rooms

    Room readiness and occupancy records tied to a booking.

    Linked to Bookings
  • Bookings

    Member reservations against a session, holding one or more places.

    Linked to Members, Sessions
  • Therapist allocations

    Therapist and room time reserved for a specific booking.

    Linked to Bookings, People, Treatment rooms

Members and packages

4 tablesAbout this feature
  • Members

    Spa members with membership lifecycle status.

  • Membership plans

    Sellable membership products with price, session allowance and validity.

  • Member plans

    A member's enrolment in a membership plan for a validity window.

    Linked to Members, Membership plans
  • Bookings

    Member reservations against a session, holding one or more places.

    Linked to Members, Sessions

Payments

4 tablesAbout this feature
  • Payments

    Receipts and pending charges against member bookings.

    Linked to Members, Bookings
  • Bookings

    Member reservations against a session, holding one or more places.

    Linked to Members, Sessions
  • Members

    Spa members with membership lifecycle status.

  • Member plans

    A member's enrolment in a membership plan for a validity window.

    Linked to Members, Membership plans

Shared and settings

1 table
  • Users

    Users

    Linked to Users

Keys and references

A booking references its member and session; attendance references the booking and who recorded it; a payment references the member and booking. A therapist allocation references the booking, therapist and room; a room references the booking it is serving. Sessions reference their service and therapist. Enrolments reference the member and package. Keep member numbers and room names stable from your current system and import by them.

Migration order

  1. Load Users and People, then Services, treatment rooms and membership plans.
  2. Load Members with their status and join date.
  3. Load current member plans enrolments.
  4. Load the coming weeks’ Sessions and their Bookings.
  5. Load therapist allocations for confirmed bookings, and open Payments.
  6. Reconcile members, packages and open bookings with the current system and test permissions before go-live.

Set up Spa & Wellness Management your way.

Start free, then use Proto to change fields, steps and approvals before your team goes live.

How to get started