These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Spa & Wellness Center
- Data model and import order
The tables behind Spa & Wellness Center
Spa & Wellness Center 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, People. Each session belongs to a treatment and a therapist.
Bookings:
Bookings link a member to a session with places and status.
Memberships and Packages:
Members, membership plans, member plans and treatment packages.
Attendance:
Attendance records one check-in per delivered booking.
Payments:
Payments link a member and a booking.
Therapist Qualifications:
Therapist qualifications link a therapist to a treatment type with certificate and expiry.
Access:
People link staff to platform users in Users.
Every table, by feature
- Treatments and Sessions3
- Bookings4
- Memberships and Packages4
- Attendance4
- Payments3
- Therapist Qualifications3
- Shared and settings1
- Services
Treatments and classes offered by the center
- Sessions
Scheduled treatment and class sessions
Linked to Services, People - People
Staff and therapists of the wellness center
Linked to Users
- Bookings
Member bookings against scheduled sessions
Linked to Members, Sessions - Sessions
Scheduled treatment and class sessions
Linked to Services, People - Members
Spa members and their membership status
- Payments
Payments received against bookings
Linked to Members, Bookings
- Members
Spa members and their membership status
- Member plans
Membership plan subscriptions held by members
Linked to Members, Membership plans - Membership plans
Membership plan catalogue with price and allowance
- Treatment packages
Prepaid treatment session packages held by members
Linked to Members
- Attendance
Check-in records for confirmed bookings
Linked to People, Bookings - Bookings
Member bookings against scheduled sessions
Linked to Members, Sessions - Sessions
Scheduled treatment and class sessions
Linked to Services, People - People
Staff and therapists of the wellness center
Linked to Users
- Payments
Payments received against bookings
Linked to Members, Bookings - Bookings
Member bookings against scheduled sessions
Linked to Members, Sessions - Members
Spa members and their membership status
- Therapist qualifications
Therapist treatment certifications and expiry
Linked to People - People
Staff and therapists of the wellness center
Linked to Users - Sessions
Scheduled treatment and class sessions
Linked to Services, People
Keys and references
Every member keeps a stable member number. Import bookings by member number and session. Load package balances with purchased and used sessions as they stand today.
The app holds 12 tables and 14 relationships.
Migration order
- Load Users and People.
- Load Services and membership plans.
- Load Members, member plans and treatment packages.
- Load therapist qualifications with certificate files.
- Load Sessions for the pilot weeks, then Bookings and open Payments.
- Reconcile members, package balances and confirmed bookings with the source before opening bookings.
Set up Spa & Wellness Center your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.