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.
- Swimming Pool Management
- Data model and import order
The tables behind Swimming Pool Management
Swimming Pool 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
Lessons and Sessions:
Services, Sessions, People. Each session belongs to a service and an instructor.
Bookings and Lanes:
Bookings link a member to a session; lane bookings split a booking into lanes with times and swimmer counts.
Memberships:
Members, membership plans and member plans. A member plan links one member to one plan with dates.
Attendance:
Attendance records one check-in per delivered booking with the recorder.
Payments:
Payments link a member and a booking with amount, date and status.
Water Quality:
Pool water checks record readings and result, linked to the booking record of the session.
Access:
People link staff to platform users in Users.
Every table, by feature
- Lessons and Sessions3
- Bookings and Lanes4
- Memberships3
- Attendance4
- Payments3
- Water Quality4
- Shared and settings1
- Services
Bookable service catalogue such as swim lessons and lane hire.
- Sessions
Scheduled deliveries of a service with instructor and capacity.
Linked to Services, People - People
Staff, instructors and reviewers who operate the aquatics center.
Linked to Users
- Bookings
A member's reserved places on a session.
Linked to Members, Sessions - Lane bookings
Lane-level reservations with interval and swimmer count.
Linked to Bookings - Sessions
Scheduled deliveries of a service with instructor and capacity.
Linked to Services, People - Members
Customers holding a membership or paying per session.
- Members
Customers holding a membership or paying per session.
- Member plans
A member's active membership period and its lifecycle state.
Linked to Members, Membership plans - Membership plans
Sellable membership products with price and session allowance.
- Attendance
Check-in evidence recorded when a confirmed booking is delivered.
Linked to Bookings, People - Bookings
A member's reserved places on a session.
Linked to Members, Sessions - Sessions
Scheduled deliveries of a service with instructor and capacity.
Linked to Services, People - People
Staff, instructors and reviewers who operate the aquatics center.
Linked to Users
- Payments
Charges raised against a booking and their reconciliation state.
Linked to Members, Bookings - Bookings
A member's reserved places on a session.
Linked to Members, Sessions - Members
Customers holding a membership or paying per session.
- Pool water checks
Pool chemistry and temperature readings with a reviewable result.
Linked to Bookings - Bookings
A member's reserved places on a session.
Linked to Members, Sessions - Sessions
Scheduled deliveries of a service with instructor and capacity.
Linked to Services, People - People
Staff, instructors and reviewers who operate the aquatics center.
Linked to Users
Keys and references
Every member keeps a stable member number. Import bookings by member number and session, never by name. Each lane booking references its booking. Each water check keeps its pool name and time.
The app holds 12 tables and 14 relationships.
Migration order
- Load Users and People.
- Load Services and membership plans.
- Load Members, then member plans.
- Load Sessions for the pilot weeks, then Bookings and lane bookings.
- Load open Payments.
- Reconcile members, active plans and confirmed places with the source before opening bookings.
Set up Swimming Pool Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.