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.
- Cafeteria Management System
- Data model
The tables behind Cafeteria Management System
Cafeteria 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
- Change it
- Add fields and tables in Proto
How the model is organised
Meal Bookings
Meal bookings links Diners through Diner and dining areas through dining area. Serve date, service end date and diner count define the service request.
Dining Areas and Rates
Dining areas holds area type, seating capacity and Status. Rate plans holds area type, starts at, ends at, rate per meal and minimum meals. Exchange rates is a read-only reference source.
Service Tasks
Service tasks links dining area, meal booking and assigned to. The assignee references team members, whose User references Users.
Counter Operations
Counter bookings and counter charges each reference meal bookings through meal booking. Counter type on counter bookings supports Restaurant and Spa.
Charges and Payments
Meal charges and Payments reference the parent meal bookings record. Financial Status values distinguish draft or posted charges from pending or confirmed receipts.
Service Completion
Meal bookings, dining areas and service tasks retain distinct lifecycle states. Checked out booking status, Cleaning area status and Completed task status describe different outcomes.
Every table, by feature
- Meal Bookings6
- Dining Areas and Rates5
- Service Tasks5
- Counter Operations5
- Charges and Payments5
- Service Completion7
- Meal bookings
Meal bookings with serve date, service end date, diner count and rate per meal.
Linked to Diners, Dining areas - Diners
Diners, groups and other meal service parties.
- Dining areas
Bookable dining inventory: seating areas, tables and other service resources.
- Rate plans
Dated meal rate plans by area type with minimum meal rules.
- Team members
Staff members who own and are assigned cafeteria service work.
Linked to Users - Users
Users
Linked to Users
- Dining areas
Bookable dining inventory: seating areas, tables and other service resources.
- Rate plans
Dated meal rate plans by area type with minimum meal rules.
- Meal bookings
Meal bookings with serve date, service end date, diner count and rate per meal.
Linked to Diners, Dining areas - Service tasks
Cleaning, maintenance and diner service work assigned to staff for a dining area and meal booking.
Linked to Dining areas, Team members, Meal bookings - Exchange rates
Read-only effective exchange rates for this app.
- Service tasks
Cleaning, maintenance and diner service work assigned to staff for a dining area and meal booking.
Linked to Dining areas, Team members, Meal bookings - Team members
Staff members who own and are assigned cafeteria service work.
Linked to Users - Users
Users
Linked to Users - Dining areas
Bookable dining inventory: seating areas, tables and other service resources.
- Meal bookings
Meal bookings with serve date, service end date, diner count and rate per meal.
Linked to Diners, Dining areas
- Counter bookings
Dining and wellness counter bookings attached to a meal booking.
Linked to Meal bookings - Counter charges
Dining and wellness counter charges posted against a meal booking.
Linked to Meal bookings - Meal bookings
Meal bookings with serve date, service end date, diner count and rate per meal.
Linked to Diners, Dining areas - Diners
Diners, groups and other meal service parties.
- Team members
Staff members who own and are assigned cafeteria service work.
Linked to Users
- Meal charges
Diner meal charges for a meal booking, draft through posted or voided.
Linked to Meal bookings - Counter charges
Dining and wellness counter charges posted against a meal booking.
Linked to Meal bookings - Payments
Diner payments received against a meal booking, pending through confirmed or refunded.
Linked to Meal bookings - Meal bookings
Meal bookings with serve date, service end date, diner count and rate per meal.
Linked to Diners, Dining areas - Rate plans
Dated meal rate plans by area type with minimum meal rules.
- Meal bookings
Meal bookings with serve date, service end date, diner count and rate per meal.
Linked to Diners, Dining areas - Dining areas
Bookable dining inventory: seating areas, tables and other service resources.
- Meal charges
Diner meal charges for a meal booking, draft through posted or voided.
Linked to Meal bookings - Counter charges
Dining and wellness counter charges posted against a meal booking.
Linked to Meal bookings - Payments
Diner payments received against a meal booking, pending through confirmed or refunded.
Linked to Meal bookings - Service tasks
Cleaning, maintenance and diner service work assigned to staff for a dining area and meal booking.
Linked to Dining areas, Team members, Meal bookings - Team members
Staff members who own and are assigned cafeteria service work.
Linked to Users
Keys and references
Preserve reservation number as the human meal-booking number and the source identifiers used by references. Link child charges, payments, counter work and service tasks to the intended meal bookings record. A service tasks.dining area reference must agree with the relevant booking context before staff act on the task.
Rate plans.area type is text rather than a reference to dining areas. Agree how area-type values are matched during setup. Resolve service tasks.assigned to through team members.User for personal task access. Users.User is a self-reference that needs an established identity mapping before migration. Exchange rates uses ID as its identifier.
Migration order
- Establish Users and team members identity mappings, including Active and role name.
- Import Diners and dining areas with recognizable numbers, area types and seating capacity.
- Prepare rate plans and read-only exchange rates with their effective dates and agreed amount interpretation.
- Import meal bookings with valid diner and dining-area references, service dates and lifecycle status.
- Link counter bookings, meal charges, counter charges and Payments to their parent bookings, preserving financial statuses and references.
- Import service tasks with the correct area, booking and staff assignee; reconcile open work before enabling service actions.
Set up Cafeteria Management System your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.