Customers

CustomerIDNamePhoneNumberEmail
1John Doe+1234567890johndoe@example.com
2Jane Smith+0987654321janesmith@example.com

Orders

OrderIDCustomerIDDateOfOrderTotalAmount
(→ Customers.CustomerID)
112022-01-01 10:00:0050.0
222022-01-02 15:30:0075.0

Staff

StaffIDPositionKitchen_PersonnelExperienceWage
1Manager30000
2Sous ChefYes5 years25000
3Sous ChefNo1 year24000
4CookYes5 years20000
5CookNo2 years19000

Food

FoodItemIDItemNameDescriptionPriceStockQuantityStaffID
(→ Staff.StaffID)
1Pizza MargheritaClassic Italian pizza with tomato sauce, mozzarella cheese, basil leaves.151001
2Grilled SalmonFresh salmon fillet grilled to perfection.25502