## Restaurants

id | name | type | year_of_establishment
--- | --- | --- | ---
1 | Peppercorn | Steakhouse | 1980
2 | The Prime Rib | Steakhouse | 2000
3 | Coastal Breeze | Seafood | 1980
4 | Fish Market | Seafood | 2005
5 | Sunny Side Cafe | Coffee Shop | 2015

## Steakhouses

restaurant_id | specialties
--- | ---
(→ Restaurants.id) |
1 | Angus Beef
2 | Wagyu Beef

## Seafood_Restaurants

restaurant_id | specialties
--- | ---
(→ Restaurants.id) |
3 | Lobster Thermidor
4 | Grilled Salmon

## Customers

customer_id | first_name | last_name | email
--- | --- | --- | ---
1 | John | Doe | john@example.com
2 | Jane | Smith | jane@example.com
3 | Alice | Williams | alice@example.com
4 | Bob | Miller | bob@example.com
5 | Charlie | Jackson | charlie@example.com

## Reservations

reservation_id | customer_id | restaurant_id | date | time | number_of_people | status
--- | --- | --- | --- | --- | --- | ---
| (→ Customers.customer_id) | (→ Restaurants.id) |  |  |  |
1 | 1 | 1 | 2021-12-20 | 17:00 | 2 | Confirmed
2 | 2 | 2 | 2021-12-21 | 19:00 | 4 | Pending
3 | 3 | 3 | 2021-12-22 | 18:30 | 6 | Canceled
4 | 4 | 4 | 2021-12-23 | 17:00 | 8 | Confirm
5 | 5 | 5 | 2021-12-24 | 19:30 | 10 | Waitlisted

## Reviews

review_id | customer_id | rating | comments
--- | --- | --- | ---
| (→ Customers.customer_id) |  |
1 | 1 | 5 | Excellent food and service!
2 | 2 | 4 | Good experience but could have been better.
3 | 3 | 3 | Not bad, but not great either.
4 | 4 | 5 | Awesome place, will come back again!
5 | 5 | 2 | Disappointing, did not meet expectations.