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 | name | type | price |
---|---|---|---|
1 | Spot A | Day Spa | 150.0 |
2 | Spot B | Day Spa | 200.0 |
3 | Spot C | Wellness Retreat | 150.0 |
4 | Spot D | Wellness Retreat | 250.0 |