Customers

customer_idfirst_namelast_nameemail
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com
3MichaelBrownmichael.brown@example.com
4EmmaGreenemma.green@example.com

Reservations

reservation_idrestaurant_typeyear_of_establishmentcustomer_id
(→ Restaurants.restaurant_type)(→ Customers.customer_id)
1Steakhouse19801
2Steakhouse20102
3Seafood Restaurant19803
4Seafood Restaurant20054

Restaurants

restaurant_idnamerestaurant_type
1The Steak HouseSteakhouse
2New York Steak HouseSteakhouse
3Fresh Fish CornerSeafood Restaurant
4Blue Ocean DelightsSeafood Restaurant

Years

year_idestablishment_year
11980
22010
32005