Reservations

reservation_idcustomer_namephone_numberdatetime
1John Doe+1-123-456-78902023-01-0118:30
2Jane Smith+1-987-654-32102023-01-0219:00

Customers

customer_idnameemailaddressphone_number
1John Doejohn@example.com123 Main St, Anytown, USA+1-123-456-7890
2Jane Smithjane@example.com456 Elm St, Anycity, USA+1-987-654-3210

MenuItems

item_idrestaurant_iditem_namedescriptionprice
(→ Restaurants.restaurant_id)
11SteakGrilled steak with garlic butter29.99
21Seafood PlatterAssorted seafood with lemon herb sauce34.99

Restaurants

restaurant_idnamelocationexecutive_chefsous_chefcuisine
1Gourmet GrillDowntownChef JohnsonChef BrownSteaks & Seafood

Reviews

review_idcustomer_idratingcomments
(→ Customers.customer_id)
115Great food and service!
224Nice place but could use improvement on presentation.

Employees

employee_idfirst_namelast_namepositionhire_datewage
1MichaelSmithManager2022-05-0150000
2EmilyJohnsonServer2022-06-0125000