1. Catering Management
  2. Data model
Reference

The tables behind Catering Management

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

How the model is organised

Event commitment:

Event orders owns event order lines and links the responsible team members and event venues.

Menu and stock:

Products links to versioned event menus; recipe yields links the recipe to Ingredients, with ingredient movements recording signed use and waste.

Kitchen and service:

Production tickets belongs to event orders; fulfillment events links orders to Products and records physical event types.

Review:

Operation receipts, review decisions, record attachments and payment evidence retain outcomes and supporting evidence for event orders.

Operating context:

Organizations links venues, orders and team members; team members links to Users.

Every table, by feature

Event orders

5 tablesAbout this feature
  • Event orders

    Customer orders accepted and fulfilled by the kitchen and service team.

    Linked to Organizations, Team members, Event venues
  • Event order lines

    Individual menu item lines within a meal order.

    Linked to Event orders
  • Event venues

    Dining rooms, outlets, venues and delivery destinations served by the operation.

    Linked to Organizations
  • Team members

    Staff members linked to an organization and platform identity.

    Linked to Organizations, Users
  • Operation receipts

    Durable receipts for guarded operations and their outcomes.

    Linked to Event orders

Kitchen production

6 tablesAbout this feature
  • Production tickets

    Kitchen tickets submitted for review and release against a meal order.

    Linked to Event orders, Organizations
  • Event orders

    Customer orders accepted and fulfilled by the kitchen and service team.

    Linked to Organizations, Team members, Event venues
  • Event order lines

    Individual menu item lines within a meal order.

    Linked to Event orders
  • Event menus

    Versioned recipe headers for products, with yield and approval state.

    Linked to Products
  • Review decisions

    Independent reviewer decisions on submitted revisions.

    Linked to Event orders, Team members
  • Operation receipts

    Durable receipts for guarded operations and their outcomes.

    Linked to Event orders

Event service

5 tablesAbout this feature
  • Event orders

    Customer orders accepted and fulfilled by the kitchen and service team.

    Linked to Organizations, Team members, Event venues
  • Event order lines

    Individual menu item lines within a meal order.

    Linked to Event orders
  • Fulfillment events

    Allocation, picking, shipping, delivery and return events.

    Linked to Event orders, Products
  • Event venues

    Dining rooms, outlets, venues and delivery destinations served by the operation.

    Linked to Organizations
  • Operation receipts

    Durable receipts for guarded operations and their outcomes.

    Linked to Event orders

Venues and teams

5 tablesAbout this feature
  • Organizations

    Operating organizations within the food and beverage group.

  • Event venues

    Dining rooms, outlets, venues and delivery destinations served by the operation.

    Linked to Organizations
  • Team members

    Staff members linked to an organization and platform identity.

    Linked to Organizations, Users
  • Users

    Users

    Linked to Users
  • Event orders

    Customer orders accepted and fulfilled by the kitchen and service team.

    Linked to Organizations, Team members, Event venues

Review and evidence

5 tablesAbout this feature
  • Operation receipts

    Durable receipts for guarded operations and their outcomes.

    Linked to Event orders
  • Review decisions

    Independent reviewer decisions on submitted revisions.

    Linked to Event orders, Team members
  • Record attachments

    Files and evidence attached to operational records.

    Linked to Event orders, Team members
  • Payment evidence

    Provider-issued authorization, capture, refund and void receipts.

    Linked to Event orders
  • Event orders

    Customer orders accepted and fulfilled by the kitchen and service team.

    Linked to Organizations, Team members, Event venues

Shared and settings

1 table
  • Exchange rates

    Read-only effective exchange rates for this app.

Keys and references

Use the order record number for human coordination and its Id for references. Preserve revision values on orders, lines and tickets when reviewing a changed scope. Operation key and provider event identifiers distinguish a repeated delivery from a new effect. A review decision names the source revision and actual reviewer. Keep attachment visibility with the evidence.

Migration order

  1. Create Organizations and Users, then team members and event venues.
  2. Load Products and Ingredients, followed by event menus and recipe yields.
  3. Load event orders and event order lines with their current revisions and served history.
  4. Link production tickets, fulfillment events and ingredient movements to the source work.
  5. Bring across review decisions, operation receipts, record attachments and payment evidence with their original identities and outcomes.
  6. Verify exchange rates and reconcile imported source records before operational use.

Set up Catering Management your way.

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

How to get started