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.
- Hotel + Restaurant + Spa
- Data model
The tables behind Hotel + Restaurant + Spa
Hotel + Restaurant + Spa 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
- Change it
- Add fields and tables in Proto
How the model is organised
Stay records
Parties, Reservations, Units and rate plans establish the guest, booked resource, dates and price context.
Service records
Service tasks and People attach assigned work to a unit and reservation; Users identifies the staff account.
Outlet records
Outlet bookings and outlet charges attach restaurant or spa activity to the reservation.
Finance records
Folio charges and Payments let Finance Officer review charges and confirmed receipts. Exchange rates holds effective read-only rates.
Every table, by feature
- Reservations4
- Units and rates4
- Guests and staff6
- Check-in and service6
- Restaurant and spa5
- Folio and payments6
- Reservations
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Parties, Units - Parties
Guests, groups, companies and other booking parties.
- Units
Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.
- Rate plans
Dated nightly rate plans by unit type with minimum stay rules.
- Units
Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.
- Rate plans
Dated nightly rate plans by unit type with minimum stay rules.
- Reservations
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Parties, Units - Service tasks
Housekeeping, maintenance and guest service work assigned to staff for a unit and reservation.
Linked to Units, People, Reservations
- Parties
Guests, groups, companies and other booking parties.
- People
Staff members who own and are assigned hospitality service work.
Linked to Users - Users
Users
Linked to Users - Reservations
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Parties, Units - Service tasks
Housekeeping, maintenance and guest service work assigned to staff for a unit and reservation.
Linked to Units, People, Reservations - Outlet bookings
Restaurant, spa and other outlet bookings attached to a reservation.
Linked to Reservations
- Reservations
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Parties, Units - Units
Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.
- Service tasks
Housekeeping, maintenance and guest service work assigned to staff for a unit and reservation.
Linked to Units, People, Reservations - People
Staff members who own and are assigned hospitality service work.
Linked to Users - Folio charges
Guest folio charges for a reservation, draft through posted or voided.
Linked to Reservations - Payments
Guest payments received against a reservation, pending through confirmed or refunded.
Linked to Reservations
- Outlet bookings
Restaurant, spa and other outlet bookings attached to a reservation.
Linked to Reservations - Outlet charges
Restaurant, spa and other outlet charges posted against a reservation.
Linked to Reservations - Reservations
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Parties, Units - Parties
Guests, groups, companies and other booking parties.
- Payments
Guest payments received against a reservation, pending through confirmed or refunded.
Linked to Reservations
- Folio charges
Guest folio charges for a reservation, draft through posted or voided.
Linked to Reservations - Outlet charges
Restaurant, spa and other outlet charges posted against a reservation.
Linked to Reservations - Payments
Guest payments received against a reservation, pending through confirmed or refunded.
Linked to Reservations - Reservations
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Parties, Units - Units
Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.
- Exchange rates
Read-only effective exchange rates for this app.
Keys and references
The reservation is the primary join for the operating cycle. It points to one guest party and one unit. Folio charges, outlet bookings, outlet charges, payments and service tasks each point back to that reservation. A service task also points to its unit and assigned person; a person points to a user. This lets the team explain an amount or service action from the guest’s stay rather than from a detached note.
Migration order
- Load Users and People and check staff identity and access.
- Load Parties, Units and rate plans, then review unit capacity and pricing periods.
- Load active Reservations with their guest and unit references.
- Load service tasks, outlet bookings, folio charges, outlet charges and Payments against the correct reservation.
- Check exchange rates and reconcile effective dates and currencies with the financial process.
Set up Hotel + Restaurant + Spa your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.