reservation_id | customer_name | phone_number | date | time |
---|---|---|---|---|
1 | John Doe | +1-123-456-7890 | 2023-01-01 | 18:30 |
2 | Jane Smith | +1-987-654-3210 | 2023-01-02 | 19:00 |
customer_id | name | address | phone_number | |
---|---|---|---|---|
1 | John Doe | john@example.com | 123 Main St, Anytown, USA | +1-123-456-7890 |
2 | Jane Smith | jane@example.com | 456 Elm St, Anycity, USA | +1-987-654-3210 |
item_id | restaurant_id | item_name | description | price |
---|---|---|---|---|
(→ Restaurants.restaurant_id) | ||||
1 | 1 | Steak | Grilled steak with garlic butter | 29.99 |
2 | 1 | Seafood Platter | Assorted seafood with lemon herb sauce | 34.99 |
restaurant_id | name | location | executive_chef | sous_chef | cuisine |
---|---|---|---|---|---|
1 | Gourmet Grill | Downtown | Chef Johnson | Chef Brown | Steaks & Seafood |
review_id | customer_id | rating | comments |
---|---|---|---|
(→ Customers.customer_id) | |||
1 | 1 | 5 | Great food and service! |
2 | 2 | 4 | Nice place but could use improvement on presentation. |
employee_id | first_name | last_name | position | hire_date | wage |
---|---|---|---|---|---|
1 | Michael | Smith | Manager | 2022-05-01 | 50000 |
2 | Emily | Johnson | Server | 2022-06-01 | 25000 |