Flights

Flight_IDDeparture_TimeArrival_TimeDurationSeatsIATA_DepartureICAO_ArrivalPriceForeignKey_Airline
(→ Airports.IATA_Code)(→ Airports.ICAO_Code)(→ Airlines.Airlines_Id)
12023-01-01 08:00:002023-01-01 12:00:00180250JFKKATL2501
22023-01-02 09:00:002023-01-02 13:00:00180250LAXKSFO2602
32023-01-03 10:00:002023-01-03 14:00:00180250ORDKPHX2403
42023-01-04 11:00:002023-01-04 15:00:00180250DFWKEWR2504
52023-01-05 12:00:002023-01-05 16:00:00180250MIAKSEA2601

Airlines

Airlines_IdNameCallsignHeadquarters
1United AirlinesUALChicago
2Delta Air LinesDLAtlanta
3American AirlinesAAFort Worth
4Southwest AirlinesWNDallas
5Alaska AirlinesASSeattle

Airports

idGeographical_PositionIATA_CodeICAO_CodeAltitude
(→ Flights.IATA_Departure)(→ Flights.ICAO_Arrival)
1New YorkJFKKJFK12
2Los AngelesLAXKLAX30
3ChicagoORDKORD601
4DallasDFWKDFW465
5MiamiMIAKMIA10