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 |