123
Tables (5)
Management (Untitled4)
- ManagerID (Key) — Primary key — NOT NULL
- MenuID (Field)
- PaymentID (Field2)
- SoldOut (Field3)
- Revenue (Field4)
Menu (Untitled5)
- MenuID (Key) — Primary key — NOT NULL
- MenuName (Field)
- Category (Field2)
- Option (Field3)
- Price (Field4)
Order (Untitled)
- OrderID (Key) — Primary key — NOT NULL
- ItemsID (Field)
- Total (Field2)
- Orderdate (Field3)
Orderitems (Untitled2)
- ItemsID (Key) — Primary key — NOT NULL
- MenuID (Field)
- Price (Field2)
- Quantity (Field3)
- Subtotal (Field4)
Payment (Untitled3)
- PaymentID (Key) — Primary key — NOT NULL
- OrderID (Field)
- PaymentAmount (Field2)
- PaymentMethod (Field3)
- PaymentDate (Field4)