| 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 |
| restaurant_id | specialties |
|---|---|
| (→ Restaurants.id) | |
| 1 | Angus Beef |
| 2 | Wagyu Beef |
| restaurant_id | specialties |
|---|---|
| (→ Restaurants.id) | |
| 3 | Lobster Thermidor |
| 4 | Grilled Salmon |
| customer_id | first_name | last_name | |
|---|---|---|---|
| 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 |
| 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 |
| 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. |