Airlines

idairline_nameallianceindependent_carrier
(→ Alliances.id)(→ Carriers.id)
1American Airlines10
2United Airlines01
3Delta Airlines10
4Southwest Airlines11
5JetBlue Airways01

Aircrafts

idmodelseats
1Airbus A320180
2Boeing 777360
3Embraer E190100

Flights

idairport_departureairport_arrivalairline_idaircraft_modeldeparture_timearrival_time
(→ Airports.id)(→ Airports.id)(→ Airlines.id)(→ Aircrafts.id)
1NoneNone112023-01-01 09:00:002023-01-01 12:00:00
2NoneNone222023-01-01 10:00:002023-01-01 14:00:00
3NoneNone332023-01-01 11:00:002023-01-01 15:00:00
4NoneNone412023-01-01 12:00:002023-01-01 16:00:00
5NoneNone522023-01-01 13:00:002023-01-01 17:00:00

Alliances

idalliance_name
1Star Alliance
2OneWorld
3SkyTeam

Carriers

idcarrier_name
1Boeing
2Embraer
3Airbus