RoomAmenities
amenID | amenName | amenCost |
1 | Free WiFi | 0.0 |
2 | Parking | 10.99 |
3 | Gym Access | 2.5 |
4 | Breakfast Included | 8.75 |
5 | Laundry Service | 3.0 |
Guests
guestID | firstName | lastName | email | phoneNumber |
1 | John | Doe | john@example.com | +1-555-123-4567 |
2 | Jane | Smith | jane@example.com | +1-555-987-6543 |
3 | Michael | Brown | michael@example.com | +1-555-321-9876 |
4 | Emily | White | emily@example.com | +1-555-135-7890 |
5 | David | Black | david@example.com | +1-555-456-1234 |
GuestHouses
houseID | houseName | location | capacity | pricePerNight |
1 | Cozy Inn | New York City | 10 | 150.0 |
2 | Urban Retreat | Los Angeles | 15 | 200.0 |
3 | Mountain Lodge | Denver | 8 | 180.0 |
4 | Beachfront Paradise | Miami Beach | 12 | 250.0 |
5 | City Center Suite | Chicago | 6 | 175.0 |
Suites
suiteType |
Standard Suite |
Deluxe Suite |
Executive Suite |
Family Suite |
GuestHouseSuites
guesthouseID | suiteType |
(→ GuestHouses.houseID) | (→ Suites.suiteType) |
1 | Standard Suite |
1 | Family Suite |
2 | Deluxe Suite |
2 | Family Suite |
3 | Standard Suite |
3 | Family Suite |
4 | Deluxe Suite |
4 | Executive Suite |
5 | Deluxe Suite |
5 | Family Suite |
3 | Deluxe Suite |
4 | Family Suite |
5 | Standard Suite |