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.
- Commissary Kitchen Management
- Data model
The tables behind Commissary Kitchen Management
Commissary Kitchen Management 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
Kitchen and commercial setup
Kitchens describes the space and capacity; rate plans describes effective slot rates by kitchen type.
Client commitment
Clients identifies the organization; Bookings connects it to a kitchen, interval, rate and lifecycle state.
Financial position
Booking charges and add on charges hold dated amounts; Payments holds received amounts and confirmation states.
Additional activity
Add on bookings records food or wellness service; service tasks records cleaning, maintenance and client work.
People and support data
Team members links staff to Users; exchange rates holds read-only effective rates.
Every table, by feature
- Kitchen scheduling5
- Client bookings7
- Rates and charges5
- Payments4
- Add-on services4
- Service operations5
- Shared and settings1
- Kitchens
Bookable commissary kitchens with type, station capacity and operational status.
- Bookings
Kitchen bookings with client, kitchen, dates, rate, attendee count and lifecycle status.
Linked to Clients, Kitchens - Rate plans
Rate plans by kitchen type with effective dates, slot rate and minimum slots.
- Clients
Client organizations and contacts that book shared kitchen time.
- Service tasks
Cleaning, maintenance and client service tasks for a kitchen and booking.
Linked to Kitchens, Team members, Bookings
- Bookings
Kitchen bookings with client, kitchen, dates, rate, attendee count and lifecycle status.
Linked to Clients, Kitchens - Clients
Client organizations and contacts that book shared kitchen time.
- Kitchens
Bookable commissary kitchens with type, station capacity and operational status.
- Booking charges
Charges posted against a booking, with usage date, description, amount and status.
Linked to Bookings - Payments
Payments received against a booking with amount, reference and status.
Linked to Bookings - Add on bookings
Add-on bookings captured against a booking, with add-on type, name, start and attendee count.
Linked to Bookings - Service tasks
Cleaning, maintenance and client service tasks for a kitchen and booking.
Linked to Kitchens, Team members, Bookings
- Rate plans
Rate plans by kitchen type with effective dates, slot rate and minimum slots.
- Bookings
Kitchen bookings with client, kitchen, dates, rate, attendee count and lifecycle status.
Linked to Clients, Kitchens - Booking charges
Charges posted against a booking, with usage date, description, amount and status.
Linked to Bookings - Kitchens
Bookable commissary kitchens with type, station capacity and operational status.
- Payments
Payments received against a booking with amount, reference and status.
Linked to Bookings
- Payments
Payments received against a booking with amount, reference and status.
Linked to Bookings - Bookings
Kitchen bookings with client, kitchen, dates, rate, attendee count and lifecycle status.
Linked to Clients, Kitchens - Booking charges
Charges posted against a booking, with usage date, description, amount and status.
Linked to Bookings - Add on charges
Add-on charges captured against a booking, with add-on name, charge date, amount and status.
Linked to Bookings
- Add on bookings
Add-on bookings captured against a booking, with add-on type, name, start and attendee count.
Linked to Bookings - Add on charges
Add-on charges captured against a booking, with add-on name, charge date, amount and status.
Linked to Bookings - Bookings
Kitchen bookings with client, kitchen, dates, rate, attendee count and lifecycle status.
Linked to Clients, Kitchens - Clients
Client organizations and contacts that book shared kitchen time.
- Service tasks
Cleaning, maintenance and client service tasks for a kitchen and booking.
Linked to Kitchens, Team members, Bookings - Team members
Team members linked to a platform user, with role title and active flag.
Linked to Users - Users
Users
Linked to Users - Kitchens
Bookable commissary kitchens with type, station capacity and operational status.
- Bookings
Kitchen bookings with client, kitchen, dates, rate, attendee count and lifecycle status.
Linked to Clients, Kitchens
Keys and references
Bookings is the operational center. Its Client and Kitchen references identify who uses which space. Add on bookings, add on charges, booking charges, Payments and service tasks each reference a Booking. Service tasks also references Kitchens and team members. Team members references Users. Keep those links intact during imports so related work appears on the correct booking detail.
Migration order
- Import Users and team members, then Clients.
- Add Kitchens with kitchen type, station capacity and status.
- Add rate plans with effective dates, slot rate and minimum slots.
- Load Bookings with their client and kitchen references.
- Load add on bookings, service tasks, booking charges, add on charges and Payments against the correct booking.
- Review exchange rates where currency data is part of the operating setup.
Set up Commissary Kitchen Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.