Customers

CustomerIDFirstNameLastNamePhoneNumberEmailAddress
1JohnDoe+1234567890john.doe@example.com
2JaneSmith+0987654321jane.smith@example.com
3AliceBrown+1123456789alice.brown@example.com
4CharlieBlack+0987654320charlie.black@example.com
5DavidWhite+1345678901david.white@example.com

Tables

TableIDSeatingAreaCapacity
1Patio50
2Patio40
3Veranda50
4Veranda40
5Indoor60

FloorPlan

FloorplanIDNumberOfSeatsTableId
(→ Tables.TableID)
1501
2402
3503
4404
5605

Reservations

ReservationIDCustomerIDReservedDateReservedTimeNumGuestsTableId
(→ Customers.CustomerID)(→ Tables.TableID)
112023-01-01 18:0019:0021
222023-01-02 19:0020:0042
332023-01-03 20:0021:0033
442023-01-04 21:0022:0054
552023-01-05 22:0023:0065

FoodOrders

OrderIDReservationIDMenuItemQuantitySpecialInstructionsTotalPricePaymentStatus
(→ Reservations.ReservationID)
11Steak275Paid
22Salmon390Paid
33Veggie Burger2No cheese15Paid
44Chicken Caesar Salad118Paid
55Pasta Primavera1Gluten-free20Paid