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 PMS
- Data model
The tables behind Hotel PMS
Hotel PMS 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
Stay records
Parties, Reservations, Units and rate plans hold guest identity, booked dates, inventory and pricing context.
Service records
Service tasks connects People, Units and Reservations; outlet bookings records dated restaurant and spa activity.
Financial records
Folio charges, outlet charges and Payments each link to Reservations with distinct statuses.
Access and rates
Users supports staff identity through People; exchange rates holds effective currency rates.
Every table, by feature
- Reservations4
- Units and rates4
- Front desk6
- Service work5
- Folio and payments4
- Outlets4
- Shared and settings1
- 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
- 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.
- Outlet bookings
Restaurant, spa and other outlet bookings attached to a reservation.
Linked to Reservations - Service tasks
Housekeeping, maintenance and guest service work assigned to staff for a unit and reservation.
Linked to Units, People, Reservations - Payments
Guest payments received against a reservation, pending through confirmed or refunded.
Linked to Reservations
- 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 - Users
Users
Linked to Users - Units
Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.
- Reservations
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Parties, Units
- 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 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
- 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 - Payments
Guest payments received against a reservation, pending through confirmed or refunded.
Linked to Reservations
Keys and references
Reservations.Guest points to Parties and Reservations.Unit points to Units. Service tasks.assigned to points to People, while service tasks.Unit and service tasks.Reservation identify the place and stay. People.User points to Users. Folio charges.Reservation, outlet bookings.Reservation, outlet charges.Reservation and Payments.Reservation all point to Reservations. Keep those links intact when moving historical records.
Migration order
- Identity. Prepare Users and People so staff assignment has a destination.
- Inventory. Load Units and rate plans, then the guest parties in Parties.
- Stays. Load Reservations with valid guest and unit references.
- Work and money. Load service tasks, outlet bookings, folio charges, outlet charges and Payments against their reservations.
- Review. Check the status values and dates on sampled stays before staff use the records.
Set up Hotel PMS your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.