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 |