ID | TypeName | Price |
---|---|---|
1 | Standard | 99.99 |
2 | Deluxe | 129.99 |
3 | Luxury Suite | 309.99 |
4 | Presidential Suite | 609.99 |
5 | Family Suite | 279.99 |
ID | AmenityName |
---|---|
1 | Free WiFi |
2 | Gym Access |
3 | Concierge Service |
4 | Room Service |
5 | Parking Facilities |
ID | CheckInDate | CheckOutDate | TotalNights | CustomerID |
---|---|---|---|---|
(→ Customers.ID) | ||||
1 | 2022-08-01 | 2022-08-07 | 6 | 1 |
2 | 2022-08-15 | 2022-08-21 | 6 | 2 |
3 | 2022-08-30 | 2022-09-05 | 6 | 3 |
4 | 2022-09-10 | 2022-09-17 | 7 | 4 |
5 | 2022-09-25 | 2022-09-30 | 6 | 5 |
ID | Name | PhoneNumber | |
---|---|---|---|
1 | John Doe | john@example.com | +1234567890 |
2 | Jane Smith | jane@example.com | +0987654321 |
3 | Michael Johnson | michael@example.com | +1122334455 |
4 | Emily Davis | emily@example.com | +2233445566 |
5 | William Brown | william@example.com | +3344556677 |
ID | OptionType | Price |
---|---|---|
1 | Day Spa | 150.0 |
2 | Day Spa | 200.0 |
3 | Wellness Retreat | 150.0 |
4 | Wellness Retreat | 200.0 |
ID | PackageName | Description | BasePrice | ExtraCost |
---|---|---|---|---|
(→ RelaxationOptions.Price) | ||||
1 | Honeymoon Special | Romantic package includes champagne and rose petals on arrival. | 250.0 | 75.0 |
2 | Business Traveller | Special package for business travellers including breakfast and free internet. | 300.0 | 50.0 |
3 | Fitness Enthusiast | Perfect for fitness lovers including gym access and personal trainer sessions. | 350.0 | 100.0 |
4 | Culinary Delight | Tailored packages for foodies including cooking classes and wine tasting. | 400.0 | 150.0 |
5 | Entertainment Seeker | Packed with entertainment options like tickets to local attractions and live shows. | 450.0 | 200.0 |