## Airports

id | name | location | country
--- | --- | --- | ---
1 | JFK International | Queens, NY | USA
2 | Heathrow Airport | London, UK | UK
3 | Charles de Gaulle | Paris, France | France
4 | Dubai International | Dubai, UAE | UAE
5 | Tokyo Haneda | Tokyo, Japan | Japan

## Facilities

id | facilityType | openingHours | airportId
--- | --- | --- | ---
|  |  | (→ Airports.id)
1 | Restaurant | 9 AM to 11 PM | 1
2 | Shopping Center | 6 AM to 10 PM | 2
3 | Restroom | 24 Hours | 3
4 | Luggage Storage | 7 AM to 8 PM | 4
5 | Currency Exchange | 7 AM to 9 PM | 5

## Restaurants

id | restaurantName | rating | facilitiesId
--- | --- | --- | ---
|  |  | (→ Facilities.id)
1 | Cafe des Amis | 4.5 | 1
2 | The Great British Fish and Chips | 4 | 2
3 | Ramen House | 4.5 | 3
4 | Pizza Express | 3.5 | 4
5 | Burger Joint | 4 | 5

## Bars

id | barName | capacity | facilitiesId
--- | --- | --- | ---
|  |  | (→ Facilities.id)
1 | Moonshine Bar | 50 | 1
2 | Wine Cellar | 30 | 2
3 | Beer Garden | 100 | 3
4 | Martini Lounge | 50 | 4
5 | Whisky Room | 40 | 5