## Guests

id | firstName | lastName | phoneNumber | emailAddress
--- | --- | --- | --- | ---
1 | John | Doe | +123456789 | john.doe@example.com

## Reservations

id | guestId | roomId | checkInDate | checkOutDate | totalCost
--- | --- | --- | --- | --- | ---
| (→ Guests.id) | (→ Rooms.id) |  |  |
1 | 1 | None | 2022-01-01 | 2022-01-07 | 500.0

## Rooms

id | roomType | pricePerNight
--- | --- | ---
1 | Standard | 100.0

## FunctionRooms

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