Airports

idnamecitycountry
1A1City ACountry A
2A2City BCountry B
3A3City CCountry C
4A4City DCountry D
5A5City ECountry E

Airlines

idairlineNameheadquarteredInhomeAirportId
(→ Airports.id)
1Alaska AirlinesUSANone
2Delta AirlinesUSANone
3United AirlinesUSANone
4American AirlinesUSANone
5JetBlue AirwaysUSANone

Flights

idflightNodepartureTimearrivalTimeoriginAirportIddestinationAirportIdaircraftId
(→ Airports.id)(→ Airports.id)(→ Manufactures.id)
1AA12022-01-01 10:00:002022-01-01 15:00:00121
2DL12022-01-01 11:00:002022-01-01 16:00:00232
3UA12022-01-01 12:00:002022-01-01 17:00:00343
4AS12022-01-01 13:00:002022-01-01 18:00:00454
5B612022-01-01 14:00:002022-01-01 19:00:00515

Manufactures

idaircraftModelmanufacturersnumberOfSeats
1737 MAXBoeing180
2A320neoAirbus180
3Bombardier CRJ900Canada65
4Embraer ERJ-170Brazil68
5Airbus A220Airbus130