Entertainment_Hubs

HubIDNameTypeHoursPriceRange
1Cocktail LoungeBaropen from 5 PM to 2 AMNone
2Cocktail LoungeBaropen from 3 PM to midnightNone
3Sports BarBaropen from 5 PM to 2 AMNone
4Sports BarBaropen from noon to 10 PMNone

HotelRooms

RoomIDFloorNumberViewOccupancyAmenities
12Mountain view2TV, WiFi, Air conditioning
21City view3TV, WiFi, Air conditioning

Restaurants

RestaurantIDNameCuisineOpeningTimeClosingTime
1Italian BistroItalian8 AM9 PM
2Japanese Sushi BarJapanese11 AM9 PM

ParkingLots

LotIDLocationCapacityCost
1Hotel parking lot503.0
2Mall parking lot3002.0

Reservations

ReservationIDCustomerNameContactInfoCheckInDateCheckOutDateTotalCostPaymentMethod
1John Doe(555) 555-55552023-01-012023-01-02150.0Visa
2Jane Smith(555) 555-67892023-01-152023-01-16200.0Mastercard