## Restaurants

restaurant_id | name | address | phone_number | cocktail_lounge_id | sports_bar_id | hours
--- | --- | --- | --- | --- | --- | ---
|  |  |  | (→ Cocktail_Lounges.lounge_id) | (→ Sports_Bars.bar_id) |
1 | The Fancy Bistro | 123 Main St | 555-1234 | 1 | None | Monday - Friday: 8AM - 10PM
2 | Cozy Cafe | 456 Elm St | 555-5678 | 2 | 1 | Open 24 Hours
3 | Beer Haven | 789 Maple Ave | 555-9012 | 3 | 2 | Monday - Thursday: 4PM - 2AM, Friday - Saturday: Noon - 2AM, Sunday: Closed
4 | Italian Delight | 321 Oak St | 555-1357 | None | 4 | Tuesday - Thursday: 11AM - 10PM, Friday & Saturday: 11AM - Midnight, Sunday & Monday: Closed

## Cocktail_Lounges

lounge_id | name | address | phone_number | hours
--- | --- | --- | --- | ---
1 | Martini Nights | 135 Pine St | 555-5670 | open from 5 PM to 2 AM
2 | Rooftop Rendezvous | 456 Willow St | 555-1235 | open from 4 PM to midnight
3 | Gatsby Lounge | 789 Birch St | 555-1356 | open from noon to 2 AM
4 | Exotic Oasis | 321 Palm St | 555-1457 | open from 10 AM to 1 AM

## Sports_Bars

bar_id | name | address | phone_number | hours
--- | --- | --- | --- | ---
1 | Gridiron Grill | 555 Oak Plaza | 555-9876 | open from 5 PM to 2 AM
2 | Slam Dunk Saloon | 678 Pine Blvd | 555-1236 | open from 4 PM to midnight
3 | Kickback Tavern | 987 Spruce Way | 555-1358 | open from noon to 2 AM
4 | Home Run Bar | 345 Elm Terrace | 555-1458 | open from 10 AM to 1 AM

## Employees

employee_id | first_name | last_name | position | restaurant_id
--- | --- | --- | --- | ---
|  |  |  | (→ Restaurants.restaurant_id)
1 | John | Doe | Manager | 1
2 | Jane | Smith | Waitress | 1
3 | Tom | Brown | Chef | 1
4 | Alice | Johnson | Hostess | 2
5 | Bob | Williams | Server | 2
6 | Charlie | Miller | Busser | 3
7 | David | Wilson | Head Chef | 3
8 | Eva | Jackson | Server | 4
9 | Frank | Thompson | Bartender | 4