cocktail_lounges

idnameaddressphone_numberhours
1The Mixologist123 Main St555-1234Open from 5 PM to 2 AM
2The Rooftop Lounge456 Market St555-5678Closed at midnight

sports_bars

idnameaddressphone_numberhours
1Sports Central789 Park Ave555-9012Open from 5 PM to 2 AM
2Game On!987 Lake Blvd555-1357Opens at noon, closes at 1 AM

restaurants

idnameaddressphone_numbercuisine
1La Casa Italiana321 Ocean Drive555-1123Italian
2Yum Cha Palace654 Second Street555-1415Chinese

rooms

idhotel_nameroom_typepricecapacity
1Grand HotelDeluxe Suite200.02
2Coastal InnStandard Room100.01

employees

idfirst_namelast_namepositionsalary
1JaneDoeManager80000.0
2JohnSmithBartender60000.0