id | manufacturer_name | country |
---|---|---|
1 | Boeing | USA |
2 | Airbus | France |
3 | Embraer | Brazil |
4 | Bombardier | Canada |
5 | Comac | China |
id | airport_code | name | city | country |
---|---|---|---|---|
1 | LAX | Los Angeles International Airport | Los Angeles | USA |
2 | CDG | Charles de Gaulle Airport | Paris | France |
3 | GRU | Guarulhos–Governador André Franco Montoro International Airport | São Paulo | Brazil |
4 | PEK | Capital International Airport | Beijing | China |
5 | PVG | Shanghai Pudong International Airport | Shanghai | China |
id | runway_length | runway_width | airport_id |
---|---|---|---|
(→ Airport.id) | |||
1 | 10000.0 | 150.0 | 1 |
2 | 2800.0 | 45.0 | 2 |
3 | 2400.0 | 45.0 | 3 |
4 | 3000.0 | 45.0 | 4 |
5 | 2800.0 | 45.0 | 5 |
id | flight_date | departure_airport_id | arrival_airport_id | plane_id |
---|---|---|---|---|
(→ Airport.id) | (→ Airport.id) | (→ Plane.id) | ||
1 | 2022-01-01 08:00:00 | 1 | 2 | 1 |
2 | 2022-01-01 12:00:00 | 2 | 3 | 2 |
3 | 2022-01-01 16:00:00 | 3 | 4 | 3 |
4 | 2022-01-01 20:00:00 | 4 | 5 | 4 |
5 | 2022-01-01 22:00:00 | 5 | 1 | 5 |
id | manufacturer_id | registration_number | aircraft_type | current_location |
---|---|---|---|---|
(→ Model.id) | ||||
1 | 1 | N123AB | Passenger | Los Angeles |
2 | 2 | F-HSBN | Passenger | Paris |
3 | 3 | PP-XXX | Regional Passenger | São Paulo |
4 | 4 | B-HLDY | Regional Passenger | Beijing |
5 | 5 | B-HLEU | Business Jet | Shanghai |