| id | firstName | lastName | phoneNumber | emailAddress |
|---|---|---|---|---|
| 1 | John | Doe | +123456789 | john.doe@example.com |
| id | guestId | roomId | checkInDate | checkOutDate | totalCost |
|---|---|---|---|---|---|
| (→ Guests.id) | (→ Rooms.id) | ||||
| 1 | 1 | None | 2022-01-01 | 2022-01-07 | 500.0 |
| id | roomType | pricePerNight |
|---|---|---|
| 1 | Standard | 100.0 |
| id | functionRoomName | seatingCapacity | cost |
|---|---|---|---|
| 1 | Ballroom | 200 | 1000.0 |
| 2 | Ballroom | 300 | 1500.0 |
| 3 | Green Room | 200 | 800.0 |
| 4 | Green Room | 300 | 1200.0 |