CustomerID | Name | PhoneNumber | |
---|---|---|---|
1 | John Doe | +1234567890 | johndoe@example.com |
2 | Jane Smith | +0987654321 | janesmith@example.com |
OrderID | CustomerID | DateOfOrder | TotalAmount |
---|---|---|---|
(→ Customers.CustomerID) | |||
1 | 1 | 2022-01-01 10:00:00 | 50.0 |
2 | 2 | 2022-01-02 15:30:00 | 75.0 |
StaffID | Position | Kitchen_Personnel | Experience | Wage |
---|---|---|---|---|
1 | Manager | 30000 | ||
2 | Sous Chef | Yes | 5 years | 25000 |
3 | Sous Chef | No | 1 year | 24000 |
4 | Cook | Yes | 5 years | 20000 |
5 | Cook | No | 2 years | 19000 |
FoodItemID | ItemName | Description | Price | StockQuantity | StaffID |
---|---|---|---|---|---|
(→ Staff.StaffID) | |||||
1 | Pizza Margherita | Classic Italian pizza with tomato sauce, mozzarella cheese, basil leaves. | 15 | 100 | 1 |
2 | Grilled Salmon | Fresh salmon fillet grilled to perfection. | 25 | 50 | 2 |