Smart Restaurant

Introduction

Smart Restaurant is a modern, comprehensive restaurant management system designed to meet the digitization and automation needs of the contemporary food service industry. Built with a robust Client-Server architecture and a microservices-ready approach, it provides a seamless experience for customers, staff, and management alike.

Technical Architecture

The system is designed with a clear separation of concerns, ensuring high maintainability and scalability.

Core Modules

The backend is modularized to handle complex business logic efficiently:

1. Identity & Auth: Manages JWT-based authentication and Role-Based Access Control (RBAC) for Super Admins, Admins, Kitchen staff, and Waiters.
2. Catalog & Operations: Handles menus, dynamic modifier groups (sizes, toppings), table management (QR code generation), and the smart cart.
3. Finance & Analytics: Processes bills, integrates with the VNPAY gateway, and generates real-time reports and revenue dashboards.
4. Realtime Gateway: Uses Socket.io to emit events instantly to the Kitchen Display System when orders are placed or updated.

Database Design (EER Schema)

The database strictly adheres to the Third Normal Form (3NF) to ensure data integrity and performance.

• UUID Primary Keys: Used across all tables to obscure the actual data scale and ensure global uniqueness.
• Price Snapshots: The order_items table stores the unit_price at the exact moment of ordering to guarantee financial report accuracy, even if menu prices change later.
• Soft Deletes: Implementing is_deleted flags instead of physical deletion to maintain referential integrity for historical orders.

1
-- Ensuring users can only access data within their tenant
2
CREATE POLICY "tenant_isolation_policy" ON orders
3
    FOR ALL
4
    USING (tenant_id = current_setting('app.current_tenant_id')::uuid);

Payment Integration (VNPAY)

Integrating a payment gateway requires a highly secure and reliable flow. We implemented the standard IPN (Instant Payment Notification) process.

User Interfaces

We prioritized a Mobile-first approach, acknowledging that most customers will browse the menu and order via their smartphones using QR codes.

• Customer Mobile: A clean, responsive grid layout for the menu, with a sticky bottom bar for quick access to the cart and checkout.
• Admin Dashboard: Provides a comprehensive view of real-time KPIs (revenue, active tables, popular items) with a clean, card-based layout.
• Kitchen Display System (KDS): Optimized for fast-paced kitchen environments, allowing chefs to see pending orders and mark them as ‘Ready’ with a single tap, instantly notifying the waitstaff.