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.
- Guest Feedback & Reviews
- Data model
The tables behind Guest Feedback & Reviews
Guest Feedback & Reviews 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
Reservations
Tickets links Customers to Organizations and carries the stay interval, guest count, rate and status.
Resources and rates
Organizations carries unit type, capacity and current state; rate plans carries dated nightly amounts and minimum nights; exchange rates holds effective read-only rates.
Service and outlets
Ticket events connects work to Tickets, Organizations and team members. Stay feedback connects outlet bookings to Tickets.
Money
Operation receipts and outlet charges connect charges to Tickets. Review decisions connects guest payments to Tickets.
People
Team members links staff identity to Users.
Every table, by feature
- Tickets
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Customers, Organizations - Customers
Guests, groups, companies and other booking parties.
- Organizations
Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.
- Rate plans
Dated nightly rate plans by unit type with minimum stay rules.
- Organizations
Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.
- Rate plans
Dated nightly rate plans by unit type with minimum stay rules.
- Tickets
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Customers, Organizations - Exchange rates
Read-only effective exchange rates for this app.
- Ticket events
Housekeeping, maintenance and guest service work assigned to staff for a unit and reservation.
Linked to Organizations, Team members, Tickets - Team members
Staff members who own and are assigned hospitality service work.
Linked to Users - Organizations
Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.
- Tickets
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Customers, Organizations - Users
Users
Linked to Users
- Stay feedback
Restaurant, spa and other outlet bookings attached to a reservation.
Linked to Tickets - Tickets
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Customers, Organizations - Customers
Guests, groups, companies and other booking parties.
- Outlet charges
Restaurant, spa and other outlet charges posted against a reservation.
Linked to Tickets
- Operation receipts
Guest folio charges for a reservation, draft through posted or voided.
Linked to Tickets - Outlet charges
Restaurant, spa and other outlet charges posted against a reservation.
Linked to Tickets - Tickets
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Customers, Organizations - Stay feedback
Restaurant, spa and other outlet bookings attached to a reservation.
Linked to Tickets
- Review decisions
Guest payments received against a reservation, pending through confirmed or refunded.
Linked to Tickets - Tickets
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Customers, Organizations - Operation receipts
Guest folio charges for a reservation, draft through posted or voided.
Linked to Tickets - Outlet charges
Restaurant, spa and other outlet charges posted against a reservation.
Linked to Tickets
Keys and references
The reservation is the common parent for its folio charges, outlet charges, outlet bookings, payments and service tasks. A service task also references its unit and assigned team member. Confirm that imported parties, resources and staff resolve to the intended records before importing operational history. Keep booking numbers, charge numbers, payment numbers and task numbers stable so staff can trace corrections.
Migration order
- Load Users and team members, then Customers.
- Load Organizations, rate plans and any effective exchange rates.
- Load Tickets with valid party and resource links.
- Load stay feedback and ticket events against their reservations.
- Load operation receipts, outlet charges and review decisions after their parent stays exist.
Set up Guest Feedback & Reviews your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.