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.
- Gym Management System
- Data model
The tables behind Gym Management System
Gym Management System 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
Reservation core
Members, Facilities and Bookings identify the party, bookable resource and stay.
Rate and staff reference
Membership plans holds dated rates; People links assigned staff to Users.
Service work
Equipment checks records cleaning, maintenance and guest service tasks against bookings and facilities.
Guest account
Booking charges, service charges and Payments remain separate records linked to Bookings.
Outlet visits
Trainer assignments holds restaurant or spa reservations linked to the stay.
Currency reference
Exchange rates retains effective rates.
Every table, by feature
- Stays and bookings4
- Facilities3
- Guests and rates3
- Service work5
- Guest accounts4
- Outlets4
- Shared and settings1
- Bookings
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Members, Facilities - Members
Guests, groups, companies and other booking parties.
- Facilities
Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.
- Membership plans
Dated nightly rate plans by unit type with minimum stay rules.
- Facilities
Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.
- Bookings
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Members, Facilities - Equipment checks
Housekeeping, maintenance and guest service work assigned to staff for a unit and reservation.
Linked to Facilities, People, Bookings
- Members
Guests, groups, companies and other booking parties.
- Membership plans
Dated nightly rate plans by unit type with minimum stay rules.
- Bookings
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Members, Facilities
- Equipment checks
Housekeeping, maintenance and guest service work assigned to staff for a unit and reservation.
Linked to Facilities, People, Bookings - Facilities
Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.
- Bookings
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Members, Facilities - People
Staff members who own and are assigned hospitality service work.
Linked to Users - Users
Users
Linked to Users
- Booking charges
Guest folio charges for a reservation, draft through posted or voided.
Linked to Bookings - Service charges
Restaurant, spa and other outlet charges posted against a reservation.
Linked to Bookings - Payments
Guest payments received against a reservation, pending through confirmed or refunded.
Linked to Bookings - Bookings
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Members, Facilities
- Trainer assignments
Restaurant, spa and other outlet bookings attached to a reservation.
Linked to Bookings - Service charges
Restaurant, spa and other outlet charges posted against a reservation.
Linked to Bookings - Bookings
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Members, Facilities - Members
Guests, groups, companies and other booking parties.
Keys and references
Bookings.Member references Members and Bookings.Facility references Facilities. Equipment checks links a Booking, Facility and checked by person. People.User connects staff to Users. Booking charges, Payments, service charges and trainer assignments each reference Bookings. Use reservation number, facility number and the charge or payment number to reconcile imported records before staff use them.
Migration order
- Users and People. Establish staff identity and the user reference.
- Members and Facilities. Load booking parties and resources with their current condition.
- membership plans and exchange rates. Review dated reference values.
- Bookings. Import stays with party and facility references and verify date intervals.
- equipment checks and trainer assignments. Attach work and outlet visits to the intended booking.
- booking charges, service charges and Payments. Reconcile amounts and status against source evidence.
Set up Gym Management System your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.