| id | firstName | lastName | phoneNumber |
|---|---|---|---|
| 1 | John | Doe | +123456789 |
| 2 | Jane | Smith | +987654321 |
| id | roomNumber | capacity | pricePerNight |
|---|---|---|---|
| 1 | 101 | 2 | 100.0 |
| 2 | 102 | 4 | 150.0 |
| id | guestId | roomId | checkInDate | checkOutDate |
|---|---|---|---|---|
| (→ Guests.id) | ||||
| 1 | 1 | 101 | 2023-01-01 | 2023-01-05 |
| 2 | 2 | 102 | 2023-01-06 | 2023-01-10 |
| id | type | price | availability |
|---|---|---|---|
| 1 | Day Spa | 150.0 | 1 |
| 2 | Day Spa | 200.0 | 0 |
| 3 | Wellness Retreat | 150.0 | 1 |
| 4 | Wellness Retreat | 250.0 | 0 |