## Customers

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

## Tables

TableID | SeatingArea | Capacity
--- | --- | ---
1 | Patio | 50
2 | Patio | 40
3 | Veranda | 50
4 | Veranda | 40
5 | Indoor | 60

## FloorPlan

FloorplanID | NumberOfSeats | TableId
--- | --- | ---
|  | (→ Tables.TableID)
1 | 50 | 1
2 | 40 | 2
3 | 50 | 3
4 | 40 | 4
5 | 60 | 5

## Reservations

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

## FoodOrders

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