HubID | Name | Type | Hours | PriceRange |
---|---|---|---|---|
1 | Cocktail Lounge | Bar | open from 5 PM to 2 AM | None |
2 | Cocktail Lounge | Bar | open from 3 PM to midnight | None |
3 | Sports Bar | Bar | open from 5 PM to 2 AM | None |
4 | Sports Bar | Bar | open from noon to 10 PM | None |
RoomID | FloorNumber | View | Occupancy | Amenities |
---|---|---|---|---|
1 | 2 | Mountain view | 2 | TV, WiFi, Air conditioning |
2 | 1 | City view | 3 | TV, WiFi, Air conditioning |
RestaurantID | Name | Cuisine | OpeningTime | ClosingTime |
---|---|---|---|---|
1 | Italian Bistro | Italian | 8 AM | 9 PM |
2 | Japanese Sushi Bar | Japanese | 11 AM | 9 PM |
LotID | Location | Capacity | Cost |
---|---|---|---|
1 | Hotel parking lot | 50 | 3.0 |
2 | Mall parking lot | 300 | 2.0 |
ReservationID | CustomerName | ContactInfo | CheckInDate | CheckOutDate | TotalCost | PaymentMethod |
---|---|---|---|---|---|---|
1 | John Doe | (555) 555-5555 | 2023-01-01 | 2023-01-02 | 150.0 | Visa |
2 | Jane Smith | (555) 555-6789 | 2023-01-15 | 2023-01-16 | 200.0 | Mastercard |