1. Catering Order Management
  2. Data model
Reference

The tables behind Catering Order Management

Catering Order Management ships with 14 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
14
Features
6, plus shared settings
Change it
Add fields and tables in Proto

How the model is organised

Company and people

Catering companies connects catering staff and event clients to the operating company; Users provides the staff identity reference.

Event order

Catering orders holds the event, client, billing party, coordinator, date, revision and order total.

Menu and operations

Menu items and menu selections describe the selected dishes and guest counts. Kitchen and logistics events and venue handoffs record execution and partner handoff.

Review and evidence

Approval decisions, catering exceptions, catering payments, service receipts and event documents retain decisions, issues and event evidence.

Every table, by feature

Event enquiries

4 tablesAbout this feature
  • Catering orders

    Catering orders from event enquiry through headcount planning, kitchen prep, delivery and billing.

    Linked to Catering companies, Catering staff, Event clients
  • Event clients

    Clients who book catering: hosts, venues and corporate accounts.

    Linked to Catering companies
  • Catering staff

    Event coordinators, chefs and kitchen staff who own catering orders and approvals.

    Linked to Catering companies, Users
  • Catering companies

    Catering businesses whose events, menus and billing are managed here.

Order review

3 tablesAbout this feature
  • Approval decisions

    Independent approval decisions taken on catering enquiries and exceptions.

    Linked to Catering companies, Catering staff, Catering orders
  • Catering orders

    Catering orders from event enquiry through headcount planning, kitchen prep, delivery and billing.

    Linked to Catering companies, Catering staff, Event clients
  • Catering exceptions

    Issues raised against a catering order: ingredient shortages, venue access, deposit holds and food safety.

    Linked to Catering orders, Catering staff

Kitchen coordination

4 tablesAbout this feature
  • Kitchen and logistics events

    Kitchen prep, packing, dispatch and venue set-up events for a catering order.

    Linked to Catering orders, Catering companies
  • Catering orders

    Catering orders from event enquiry through headcount planning, kitchen prep, delivery and billing.

    Linked to Catering companies, Catering staff, Event clients
  • Service receipts

    Recorded evidence of each kitchen, delivery or billing action performed on a catering order.

    Linked to Catering companies, Catering staff, Catering orders

Venue handoffs

4 tablesAbout this feature
  • Venue handoffs

    Handoffs of an event to venues, partner kitchens and logistics providers.

    Linked to Catering orders, Catering companies
  • Catering orders

    Catering orders from event enquiry through headcount planning, kitchen prep, delivery and billing.

    Linked to Catering companies, Catering staff, Event clients
  • Kitchen and logistics events

    Kitchen prep, packing, dispatch and venue set-up events for a catering order.

    Linked to Catering orders, Catering companies
  • Event documents

    Event documents: banqueting event orders, menu sheets, allergy notes and signed delivery dockets.

    Linked to Catering orders, Catering companies

Payments and evidence

4 tablesAbout this feature
  • Catering payments

    Deposits, progress payments and final settlement captured against a catering order.

    Linked to Catering orders
  • Service receipts

    Recorded evidence of each kitchen, delivery or billing action performed on a catering order.

    Linked to Catering companies, Catering staff, Catering orders
  • Event documents

    Event documents: banqueting event orders, menu sheets, allergy notes and signed delivery dockets.

    Linked to Catering orders, Catering companies
  • Catering orders

    Catering orders from event enquiry through headcount planning, kitchen prep, delivery and billing.

    Linked to Catering companies, Catering staff, Event clients

Shared and settings

1 table
  • Users

    Platform users with a role in this catering app.

    Linked to Users

Keys and references

The catering order is the shared reference across selections, payments, exceptions, approvals, documents, kitchen events, receipts and venue handoffs. Its client and billing party both reference event clients. The approver and event coordinator reference catering staff, which in turn references Users. Check the company reference wherever it appears before importing an event.

Migration order

  1. Company and identity. Import catering companies, Users and catering staff.
  2. Clients and menu. Import event clients and menu items with the correct company.
  3. Orders. Import catering orders after client, billing party and coordinator references resolve.
  4. Event detail. Import menu selections, approval decisions, kitchen and logistics events and venue handoffs.
  5. Evidence. Import catering payments, catering exceptions, service receipts and event documents against the validated orders.

Set up Catering Order Management your way.

Start free, then use Proto to change fields, steps and approvals before your team goes live.

How to get started