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 |
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 |
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 |
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 |