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.
- Food Truck POS & Route Planner
- Data model
The tables behind Food Truck POS & Route Planner
Food Truck POS & Route Planner 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
- 7, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Routes and trucks
Organizations, route stops and team members establish operating context.
Truck service
Stop orders, stop order lines and line tickets carry the accepted work and kitchen release.
Menu and stock
Products, menu recipes, recipe ingredients, Ingredients and ingredient movements keep sellable items and actual usage clear.
Review and evidence
Review decisions, operation receipts and record attachments retain decisions and guarded results.
External facts
Payment evidence and stop fulfillment events keep provider and fulfillment references with the order.
Every table, by feature
- Route stops and teams5
- Menu and recipes6
- Stop orders6
- Kitchen tickets5
- Preparation and service6
- Payments and corrections6
- Shift review and evidence6
- Shared and settings1
- Organizations
Operating organizations within the food and beverage group.
- Route stops
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 - Stop orders
Customer orders accepted and fulfilled by the kitchen and service team.
Linked to Organizations, Team members, Route stops
- Stop orders
Customer orders accepted and fulfilled by the kitchen and service team.
Linked to Organizations, Team members, Route stops - Stop order lines
Individual menu item lines within a meal order.
Linked to Stop orders - Route stops
Dining rooms, outlets, venues and delivery destinations served by the operation.
Linked to Organizations - Products
Sellable menu products and packaged goods.
- 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 Stop orders
- Line tickets
Kitchen tickets submitted for review and release against a meal order.
Linked to Stop orders, Organizations - Stop orders
Customer orders accepted and fulfilled by the kitchen and service team.
Linked to Organizations, Team members, Route stops - Review decisions
Independent reviewer decisions on submitted revisions.
Linked to Stop orders, Team members - Operation receipts
Durable receipts for guarded operations and their outcomes.
Linked to Stop orders - Record attachments
Files and evidence attached to operational records.
Linked to Stop orders, Team members
- Stop orders
Customer orders accepted and fulfilled by the kitchen and service team.
Linked to Organizations, Team members, Route stops - Stop order lines
Individual menu item lines within a meal order.
Linked to Stop orders - Recipe ingredients
Ingredient quantities required per recipe yield.
Linked to Ingredients, Menu recipes - Ingredient movements
Signed inventory movements for ingredient consumption and waste.
Linked to Ingredients - Stop fulfillment events
Allocation, picking, shipping, delivery and return events.
Linked to Stop orders, Products
- Payment evidence
Provider-issued authorization, capture, refund and void receipts.
Linked to Stop orders - Stop orders
Customer orders accepted and fulfilled by the kitchen and service team.
Linked to Organizations, Team members, Route stops - Stop order lines
Individual menu item lines within a meal order.
Linked to Stop orders - Review decisions
Independent reviewer decisions on submitted revisions.
Linked to Stop orders, Team members - Operation receipts
Durable receipts for guarded operations and their outcomes.
Linked to Stop orders - 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 Stop orders - Review decisions
Independent reviewer decisions on submitted revisions.
Linked to Stop orders, Team members - Record attachments
Files and evidence attached to operational records.
Linked to Stop orders, Team members - Stop orders
Customer orders accepted and fulfilled by the kitchen and service team.
Linked to Organizations, Team members, Route stops - Line tickets
Kitchen tickets submitted for review and release against a meal order.
Linked to Stop orders, Organizations - Payment evidence
Provider-issued authorization, capture, refund and void receipts.
Linked to Stop orders
Keys and references
The stop order is the parent for meal lines, tickets, decisions, receipts, attachments, payment evidence and fulfillment events. Route stops and team members link the order to its destination and owner. A recipe points to a product, and its ingredient lines point to ingredients. Operation keys, revisions, provider event IDs and external event IDs support review of repeated or uncertain actions. Keep source identities stable during migration.
Migration order
- Load organizations, users, team members and active route stops.
- Load ingredients, products, approved recipes and recipe ingredient quantities.
- Load open stop orders with their owners, destinations and lines.
- Load tickets, decisions, receipts and attachments with the correct parent order.
- Reconcile payment and fulfillment evidence against provider references and the order history.
Set up Food Truck POS & Route Planner your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.