## Airlines

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

## FlightRoutes

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

## Passengers

PassengerID | FirstName | LastName | DateOfBirth | Email
--- | --- | --- | --- | ---
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

## BaggageLimits

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

## AirportFacilities

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

## SecurityCheckpoints

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