## Flight

flightID | airline | departureAirport | arrivalAirport | date | duration
--- | --- | --- | --- | --- | ---
1 | United | EWR | IAH | 2023-08-01 06:00:00 | 4
2 | Delta | ATL | LAX | 2023-08-02 07:00:00 | 5
3 | American Airlines | DFW | MIA | 2023-08-03 08:00:00 | 4
4 | Southwest | MCO | PHX | 2023-08-04 09:00:00 | 3
5 | Alaska Airlines | SEA | PDX | 2023-08-05 10:00:00 | 2

## Employee

employeeID | name | position | hireDate | salary
--- | --- | --- | --- | ---
1 | John Doe | Pilot | 2020-06-01 | 100000.0
2 | Jane Smith | Flight Attendant | 2021-05-01 | 50000.0
3 | Bob Johnson | Mechanic | 2019-07-01 | 60000.0
4 | Emily Davis | Customer Service Representative | 2022-08-01 | 40000.0
5 | Chris Brown | Security Officer | 2018-09-01 | 35000.0

## Passenger

passengerID | firstName | lastName | birthdate | nationality
--- | --- | --- | --- | ---
1 | Alexander | Smith | 1990-01-15 | USA
2 | Samantha | Johnson | 1995-02-20 | UK
3 | David | Williams | 1988-03-25 | Canada
4 | Emma | Martinez | 2000-04-05 | Spain
5 | Michael | Davis | 1992-05-10 | Australia

## Restaurant

restaurantID | airportID | name | location | type | openingHours
--- | --- | --- | --- | --- | ---
1 | 1 | Grand Central Oyster Bar | Terminal A | Seafood | 9 AM to 11 PM
2 | 2 | The Flying Pizza | Terminal B | Italian | 11 AM to 9 PM
3 | 3 | Taste of Texas BBQ | Terminal C | BBQ | 10 AM to 8 PM
4 | 4 | Café de la Maison | Terminal D | French | 8 AM to 6 PM
5 | 5 | Green Leaf Salad Bar | Terminal E | Salad | 7 AM to 7 PM

## Bar

barID | airportID | name | location | capacity | openingHours
--- | --- | --- | --- | --- | ---
1 | 1 | Gateway Lounge | Concourse A | 50 | 9 AM to 11 PM
2 | 2 | Beer Garden | Concourse B | 75 | 11 AM to 9 PM
3 | 3 | Whiskey Sky | Concourse C | 100 | 10 AM to 8 PM
4 | 4 | Rooftop Wine Bar | Concourse D | 70 | 8 AM to 6 PM
5 | 5 | Sunset Margarita Bar | Concourse E | 80 | 7 AM to 7 PM