| CustomerID | FirstName | LastName | PhoneNumber | EmailAddress |
|---|---|---|---|---|
| 1 | John | Doe | +1234567890 | john.doe@example.com |
| 2 | Jane | Smith | +0987654321 | jane.smith@example.com |
| 3 | Alice | Brown | +1123456789 | alice.brown@example.com |
| 4 | Charlie | Black | +0987654320 | charlie.black@example.com |
| 5 | David | White | +1345678901 | david.white@example.com |
| TableID | SeatingArea | Capacity |
|---|---|---|
| 1 | Patio | 50 |
| 2 | Patio | 40 |
| 3 | Veranda | 50 |
| 4 | Veranda | 40 |
| 5 | Indoor | 60 |
| FloorplanID | NumberOfSeats | TableId |
|---|---|---|
| (→ Tables.TableID) | ||
| 1 | 50 | 1 |
| 2 | 40 | 2 |
| 3 | 50 | 3 |
| 4 | 40 | 4 |
| 5 | 60 | 5 |
| ReservationID | CustomerID | ReservedDate | ReservedTime | NumGuests | TableId |
|---|---|---|---|---|---|
| (→ Customers.CustomerID) | (→ Tables.TableID) | ||||
| 1 | 1 | 2023-01-01 18:00 | 19:00 | 2 | 1 |
| 2 | 2 | 2023-01-02 19:00 | 20:00 | 4 | 2 |
| 3 | 3 | 2023-01-03 20:00 | 21:00 | 3 | 3 |
| 4 | 4 | 2023-01-04 21:00 | 22:00 | 5 | 4 |
| 5 | 5 | 2023-01-05 22:00 | 23:00 | 6 | 5 |
| OrderID | ReservationID | MenuItem | Quantity | SpecialInstructions | TotalPrice | PaymentStatus |
|---|---|---|---|---|---|---|
| (→ Reservations.ReservationID) | ||||||
| 1 | 1 | Steak | 2 | 75 | Paid | |
| 2 | 2 | Salmon | 3 | 90 | Paid | |
| 3 | 3 | Veggie Burger | 2 | No cheese | 15 | Paid |
| 4 | 4 | Chicken Caesar Salad | 1 | 18 | Paid | |
| 5 | 5 | Pasta Primavera | 1 | Gluten-free | 20 | Paid |