AirlineID | Name | Headquarters | Founded | Website |
---|---|---|---|---|
1 | American Airlines | Fort Worth, Texas | 1930-04-15 | https://www.aa.com |
2 | United Airlines | Chicago, Illinois | 1926-07-01 | https://www.united.com |
3 | Delta Air Lines | Atlanta, Georgia | 1928-04-17 | https://www.delta.com |
4 | Southwest Airlines | Dallas, Texas | 1967-03-15 | https://www.southwest.com |
5 | JetBlue Airways | New York City, New York | 2000-02-11 | https://www.jetblue.com |
RouteID | OriginAirport | DestinationAirport | DepartureTime | ArrivalTime | AircraftType | SeatsAvailable |
---|---|---|---|---|---|---|
1 | DFW | LAX | 2023-03-01 07:00:00 | 2023-03-01 11:00:00 | Boeing 737 | 150 |
2 | ATL | ORD | 2023-03-01 08:00:00 | 2023-03-01 12:00:00 | Airbus A320 | 200 |
3 | SEA | SFO | 2023-03-01 09:00:00 | 2023-03-01 13:00:00 | Boeing 787 | 250 |
4 | EWR | MIA | 2023-03-01 10:00:00 | 2023-03-01 14:00:00 | Airbus A321 | 225 |
5 | IAH | LAX | 2023-03-01 11:00:00 | 2023-03-01 15:00:00 | Boeing 777 | 300 |
PassengerID | FirstName | LastName | DateOfBirth | |
---|---|---|---|---|
1 | John | Doe | 1990-01-01 | john.doe@example.com |
2 | Jane | Smith | 1992-02-15 | jane.smith@example.com |
3 | Alice | Johnson | 1988-03-20 | alice.johnson@example.com |
4 | Bob | Williams | 1991-04-05 | bob.williams@example.com |
5 | Emma | Martinez | 1993-05-10 | emma.martinez@example.com |
LimitID | BagWeightLimit | BagPieceLimit | Airlines | CheckInDeadline |
---|---|---|---|---|
1 | 30 | 2 | All | 2023-03-01 02:00:00 |
2 | 40 | 3 | Delta | 2023-03-01 03:00:00 |
3 | 35 | 2 | Southwest | 2023-03-01 04:00:00 |
4 | 25 | 1 | JetBlue | 2023-03-01 05:00:00 |
5 | 20 | 1 | Other | 2023-03-01 06:00:00 |
FacilityID | AirportName | TerminalCount | RestaurantCount | ShoppingMallCount | ParkingCapacity | WiFiAvailability |
---|---|---|---|---|---|---|
1 | DFW International Airport | 5 | 100 | 20 | 10000 | 1 |
2 | Los Angeles International Airport | 9 | 150 | 30 | 12000 | 1 |
3 | Hartsfield–Jackson Atlanta International Airport | 6 | 120 | 40 | 15000 | 1 |
4 | Seattle–Tacoma International Airport | 4 | 80 | 25 | 10000 | 1 |
5 | Newark Liberty International Airport | 3 | 60 | 15 | 12000 | 1 |
CheckpointID | AirportName | Location | OpeningHours | StaffCount | WaitTimes |
---|---|---|---|---|---|
1 | DFW International Airport | Terminal A | 04:00 - 22:00 | 100 | 30 |
2 | Los Angeles International Airport | Tom Bradley International Terminal | 04:00 - 22:00 | 120 | 45 |
3 | Hartsfield–Jackson Atlanta International Airport | Domestic Terminal North | 04:00 - 22:00 | 150 | 40 |
4 | Seattle–Tacoma International Airport | North Satellite | 04:00 - 22:00 | 80 | 35 |
5 | Newark Liberty International Airport | Terminal A | 04:00 - 22:00 | 110 | 50 |