-- Orders orders(id PK, table_id FK, staff_id FK, order_time, status, total_amount)

-- Payments payments(id PK, order_id FK, amount, method, timestamp)

-- Tables restaurant_table(id PK, table_number, capacity, status)

Restaurant Management System Project Documentation | Certified & Limited

-- Orders orders(id PK, table_id FK, staff_id FK, order_time, status, total_amount)

-- Payments payments(id PK, order_id FK, amount, method, timestamp)

-- Tables restaurant_table(id PK, table_number, capacity, status)