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. |