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