| 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 |