Restaurants

idnametypeyear_of_establishment
1PeppercornSteakhouse1980
2The Prime RibSteakhouse2000
3Coastal BreezeSeafood1980
4Fish MarketSeafood2005
5Sunny Side CafeCoffee Shop2015

Steakhouses

restaurant_idspecialties
(→ Restaurants.id)
1Angus Beef
2Wagyu Beef

Seafood_Restaurants

restaurant_idspecialties
(→ Restaurants.id)
3Lobster Thermidor
4Grilled Salmon

Customers

customer_idfirst_namelast_nameemail
1JohnDoejohn@example.com
2JaneSmithjane@example.com
3AliceWilliamsalice@example.com
4BobMillerbob@example.com
5CharlieJacksoncharlie@example.com

Reservations

reservation_idcustomer_idrestaurant_iddatetimenumber_of_peoplestatus
(→ Customers.customer_id)(→ Restaurants.id)
1112021-12-2017:002Confirmed
2222021-12-2119:004Pending
3332021-12-2218:306Canceled
4442021-12-2317:008Confirm
5552021-12-2419:3010Waitlisted

Reviews

review_idcustomer_idratingcomments
(→ Customers.customer_id)
115Excellent food and service!
224Good experience but could have been better.
333Not bad, but not great either.
445Awesome place, will come back again!
552Disappointing, did not meet expectations.