Restaurant Management

Overview

Restaurant management system schema covering front-of-house and back-of-house operations. Supports dine-in, takeout, and delivery order channels with integrated kitchen display workflows.

Key Design Decisions

• Multi-channel Orders: Unified order model for dine-in, takeout, and delivery
• Kitchen Tickets: Separate ticket lifecycle for kitchen workflow management
• Menu Modifiers: Add-ons and customizations (no onions, extra cheese) as structured data
• Table Management: Reservation system with table capacity and floor plan zones

Tables

12-15 tables covering restaurants, menus, menu items, modifiers, tables, reservations, orders, order items, kitchen tickets, staff, shifts, and customer feedback.