Restaurant Equis Architecture: React, FastAPI & PostgreSQL

Documentation Index

Fetch the complete documentation index at: https://mintlify.com/teofilobetancourt/Restaurant-Equis/llms.txt

Use this file to discover all available pages before exploring further.

​

Request Flow

1. Browser sends an HTTP request to port 80 (production) or directly to localhost:3000 / localhost:5000 (development).
2. Nginx inspects the request path:
   • Requests for /api/*, /api/docs, or /api/openapi.json are proxied to http://127.0.0.1:5000.
   • All other requests are served as static files from /var/www/restaurantequis (the compiled Vite bundle).
3. React SPA handles client-side routing for non-API requests. Unknown paths fall back to index.html via Nginx’s try_files directive, enabling SPA navigation without full-page reloads.
4. FastAPI receives proxied API requests, validates them with Pydantic, executes the business logic via SQLAlchemy, and returns JSON responses.
5. PostgreSQL is queried by SQLAlchemy — no raw SQL in application code. The ORM translates Python model operations into optimized SQL and returns mapped objects.

​

Frontend

src/
├── api/
│   └── index.ts          ← Sole API abstraction layer (all fetch calls)
├── components/
│   ├── Sidebar.tsx        ← Global navigation sidebar
│   ├── TopBar.tsx         ← Header bar with Venezuela-time clock
│   └── Toast.tsx          ← Global notification toasts
└── views/
    ├── PosView.tsx        ← Point of Sale
    ├── KitchenView.tsx    ← Kitchen display
    ├── OrdersView.tsx     ← Orders history
    ├── InventoryView.tsx  ← Inventory management
    ├── SuppliersView.tsx  ← Supplier directory
    └── ReportsView.tsx    ← KPI reports

​

Backend

1. Creates the Inventario PostgreSQL schema with CREATE SCHEMA IF NOT EXISTS.
2. Calls Base.metadata.create_all() to create all ORM-mapped tables (idempotent — safe to re-run).
3. Calls seed_initial_data() to populate empty tables with demo records.

​

Database

​

public schema — Core restaurant operations

​

Inventario schema — Supply-chain management

​

Nginx

server {
    listen 80 default_server;
    root /var/www/restaurantequis;
    index index.html;

    # Swagger UI
    location /api/docs {
        proxy_pass http://127.0.0.1:5000/docs;
    }

    # REST API — proxied to FastAPI on :5000
    location /api/ {
        proxy_pass         http://127.0.0.1:5000;
        proxy_http_version 1.1;
        proxy_set_header   Host              $host;
        proxy_set_header   X-Real-IP         $remote_addr;
        proxy_set_header   X-Forwarded-For   $proxy_add_x_forwarded_for;
        proxy_set_header   X-Forwarded-Proto $scheme;
        proxy_read_timeout 60s;
    }

    # React SPA — serve static files, fall back to index.html
    location / {
        try_files $uri $uri/ /index.html;
    }

    # Static assets — aggressive 1-year cache
    location /assets/ {
        expires 1y;
        add_header Cache-Control "public, immutable";
    }

    gzip on;
    gzip_types text/plain text/css application/javascript application/json image/svg+xml;
}

​

Environment Variables

VITE_API_URL=http://localhost:5000
VITE_WHATSAPP_NUMERO=584140000000

DB_HOST=localhost
DB_PORT=5432
DB_NAME=restaurant_equis
DB_USER=equis_user
DB_PASSWORD=CAMBIA_ESTA_CONTRASENA

API_PORT=5000

CORS_ORIGINS=http://158.220.100.226,http://localhost:5173,http://localhost:3000