## Model

id | manufacturer_name | country
--- | --- | ---
1 | Boeing | USA
2 | Airbus | France
3 | Embraer | Brazil
4 | Bombardier | Canada
5 | Comac | China

## Airport

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

## Runway

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

## Flight

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

## Plane

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