customer_id | first_name | last_name | |
---|---|---|---|
1 | John | Doe | john.doe@example.com |
2 | Jane | Smith | jane.smith@example.com |
3 | Michael | Brown | michael.brown@example.com |
4 | Emma | Green | emma.green@example.com |
reservation_id | restaurant_type | year_of_establishment | customer_id |
---|---|---|---|
(→ Restaurants.restaurant_type) | (→ Customers.customer_id) | ||
1 | Steakhouse | 1980 | 1 |
2 | Steakhouse | 2010 | 2 |
3 | Seafood Restaurant | 1980 | 3 |
4 | Seafood Restaurant | 2005 | 4 |
restaurant_id | name | restaurant_type |
---|---|---|
1 | The Steak House | Steakhouse |
2 | New York Steak House | Steakhouse |
3 | Fresh Fish Corner | Seafood Restaurant |
4 | Blue Ocean Delights | Seafood Restaurant |
year_id | establishment_year |
---|---|
1 | 1980 |
2 | 2010 |
3 | 2005 |