🍔 Food Delivery & QSR · Database ERD
Food Delivery Menu and Orders Schema
A schema for a food delivery platform: restaurants, menus, items with add-ons, customers, orders, order items and riders.
Drawing diagram…
What this diagram shows
- Menu items have variants and add-on groups
- Order items capture the price at the time of order
- Each order is assigned to one rider
Prompt used
ERD for food delivery: Restaurant has MenuCategories with MenuItems; MenuItem has AddOnGroups with AddOns (extra cheese); Customer places Orders at a Restaurant; Order has OrderItems (with selected add-ons and price at order time); Rider is assigned to Orders; Address stores delivery locations.
Mermaid code
erDiagram
RESTAURANT ||--|{ MENU_CATEGORY : has
MENU_CATEGORY ||--|{ MENU_ITEM : lists
MENU_ITEM ||--o{ ADDON_GROUP : offers
ADDON_GROUP ||--|{ ADDON : contains
CUSTOMER ||--o{ ADDRESS : saves
CUSTOMER ||--o{ ORDER : places
RESTAURANT ||--o{ ORDER : receives
ORDER ||--|{ ORDER_ITEM : contains
MENU_ITEM ||--o{ ORDER_ITEM : "ordered as"
RIDER ||--o{ ORDER : delivers
MENU_ITEM {
int id PK
int category_id FK
string name
decimal price
bool veg
}
ORDER {
int id PK
int customer_id FK
int restaurant_id FK
int rider_id FK
string status
decimal total
}
ORDER_ITEM {
int id PK
int order_id FK
int item_id FK
int quantity
decimal unit_price
}Related templates
Food Delivery Platform Architecture
A Swiggy/Zomato-style food delivery platform: customer, restaurant and rider apps, and the services that match orders, riders and payments.
Food Order to Doorstep Sequence
Everything that happens between a customer tapping Place Order and the food arriving: payment, restaurant acceptance, rider assignment, pickup and delivery.
Food Order Status State Machine
Every status of a food delivery order, from placed to delivered, including restaurant rejection, no rider and customer cancellation.
Restaurant Kitchen Order Flow
How orders from dine-in, takeaway and delivery apps flow through a restaurant kitchen display system to the pass and out.
Food Delivery Peak-Hour Scaling
How a food delivery platform scales for lunch and dinner peaks: pre-scaling, autoscaling services, sharded databases and a surge-protected dispatch.
Cloud Kitchen Operations Platform
A cloud kitchen that runs several virtual brands: orders from aggregators, a kitchen display system, inventory and dispatch.