Airplanes

idmodelcapacity
1Boeing 787 Dreamliner300
2Airbus A321neo200
3Embraer E195106
4Bombardier CRJ90086
5A380 Superjumbo853

Cabin_Classes

idclass_name
1Economy Class
2Business Class
3First Class
4Premium Economy
5Full-Flat Bed

Airports

idnamelocation
1New York JFKNew York City, USA
2Los Angeles LAXLos Angeles, USA
3Dubai DXBDubai, UAE
4London Heathrow LHRLondon, UK
5Tokyo Haneda HNDTokyo, Japan

Flights

idflight_numberdeparture_airport_idarrival_airport_idairplane_iddeparture_time
(→ Airports.id)(→ Airports.id)(→ Airplanes.id)
1AA1231212022-01-01T08:00:00Z
2DL4562522022-01-01T12:00:00Z
3BA9873432022-01-01T16:00:00Z
4QR1234142022-01-01T20:00:00Z
5JL5675352022-01-01T24:00:00Z

Airplanes_Cabin_Classes

airplane_idcabin_class_id
(→ Airplanes.id)(→ Cabin_Classes.id)
11
21
31
41
51