FoodOrder
Tables (3)
Food (food)
- FoodID (food_id) — INT — Primary key — NOT NULL
- Name (name) — VARCHAR2(50)
- Price (price) — INT(100)
- Description (description) — VARCHAR2(100)
Order (order)
- OrderID (order_id) — INT — Primary key — NOT NULL
- Order Time (order_time) — TIME
- TotalAmount (totalAmount) — INT
Order Detail (order detail)
- OrderDetailID (orderDetail_id) — INT — Primary key — NOT NULL
- OrderID (order_id) — INT — Primary key — NOT NULL
- FoodID (food_id) — INT — Primary key — NOT NULL
- Quantity (quantity) — INT