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.
- Online Food Ordering Platform
- Data model
The tables behind Online Food Ordering Platform
Online Food Ordering Platform 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
Order intake
Online orders owns the meal, while order lines carries each selected menu item and portion quantity.
Menu and stock
Products, menu recipes, recipe ingredients and Ingredients define the item and approved preparation requirements. Ingredient movements records consumption or waste.
Service
Fulfillment tickets carries the reviewed release; delivery events records actual movement events.
Evidence
Online payment evidence, review decisions, operation receipts and record attachments preserve external, human and local outcomes.
Organization
Organizations, team members, Users and delivery zones establish operating identity and destination. Exchange rates holds effective read-only rates.
Every table, by feature
- Order Intake5
- Menu and Recipes5
- Kitchen Fulfillment5
- Ticket Review5
- Payment and Corrections6
- Evidence and Exceptions6
- Shared and settings4
- Online orders
Customer orders accepted and fulfilled by the kitchen and service team.
Linked to Organizations, Team members, Delivery zones - Order lines
Individual menu item lines within a meal order.
Linked to Online orders - Products
Sellable menu products and packaged goods.
- Delivery zones
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 Online orders
- Online orders
Customer orders accepted and fulfilled by the kitchen and service team.
Linked to Organizations, Team members, Delivery zones - Order lines
Individual menu item lines within a meal order.
Linked to Online orders - Ingredient movements
Signed inventory movements for ingredient consumption and waste.
Linked to Ingredients - Delivery events
Allocation, picking, shipping, delivery and return events.
Linked to Online orders, Products
- Fulfillment tickets
Kitchen tickets submitted for review and release against a meal order.
Linked to Online orders, Organizations - Online orders
Customer orders accepted and fulfilled by the kitchen and service team.
Linked to Organizations, Team members, Delivery zones - Review decisions
Independent reviewer decisions on submitted revisions.
Linked to Online orders, Team members - Record attachments
Files and evidence attached to operational records.
Linked to Online orders, Team members - Operation receipts
Durable receipts for guarded operations and their outcomes.
Linked to Online orders
- Online payment evidence
Provider-issued authorization, capture, refund and void receipts.
Linked to Online orders - Online orders
Customer orders accepted and fulfilled by the kitchen and service team.
Linked to Organizations, Team members, Delivery zones - Order lines
Individual menu item lines within a meal order.
Linked to Online orders - Review decisions
Independent reviewer decisions on submitted revisions.
Linked to Online orders, Team members - Ingredient movements
Signed inventory movements for ingredient consumption and waste.
Linked to Ingredients - Operation receipts
Durable receipts for guarded operations and their outcomes.
Linked to Online orders
- Operation receipts
Durable receipts for guarded operations and their outcomes.
Linked to Online orders - Review decisions
Independent reviewer decisions on submitted revisions.
Linked to Online orders, Team members - Record attachments
Files and evidence attached to operational records.
Linked to Online orders, Team members - Online orders
Customer orders accepted and fulfilled by the kitchen and service team.
Linked to Organizations, Team members, Delivery zones - Delivery events
Allocation, picking, shipping, delivery and return events.
Linked to Online orders, Products - Online payment evidence
Provider-issued authorization, capture, refund and void receipts.
Linked to Online orders
Keys and references
The parent order links meal lines, tickets, payment events, delivery events, decisions, receipts and attachments. A ticket has its own revision. A decision names the source revision and reviewer. An operation receipt carries the operation key and expected revision so a repeated request can find the existing outcome.
Migration order
- Load organizations, staff identities and active delivery zones.
- Load menu products, ingredients, approved recipes and recipe ingredient requirements.
- Bring in orders and their meal lines, preserving order number and revision.
- Link tickets, decisions, payment evidence, delivery events, attachments and operation receipts to the correct parent orders.
- Reconcile signed ingredient movements against their source meal lines.
Set up Online Food Ordering Platform your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.