## Airports

id | name | city | country
--- | --- | --- | ---
1 | Airport1 | CityA | CountryX
2 | Airport2 | CityB | CountryY
3 | Airport3 | CityC | CountryZ
4 | Airport4 | CityD | CountryW
5 | Airport5 | CityE | CountryV

## Airlines

id | name | headquarter_city | headquarter_country
--- | --- | --- | ---
1 | Airline1 | HeadquartersA | HQX
2 | Airline2 | HeadquartersB | HQY
3 | Airline3 | HeadquartersC | HQZ
4 | Airline4 | HeadquartersD | HQW
5 | Airline5 | HeadquartersE | HQV

## Planes

id | model | linear_dimensions | weight_restriction | airline_id
--- | --- | --- | --- | ---
|  |  |  | (→ Airlines.id)
1 | PlaneModel1 | Dimensions1 | 10000.0 | 1
2 | PlaneModel2 | Dimensions2 | 20000.0 | 2
3 | PlaneModel3 | Dimensions3 | 30000.0 | 3
4 | PlaneModel4 | Dimensions4 | 40000.0 | 4
5 | PlaneModel5 | Dimensions5 | 50000.0 | 5

## Runways

id | length | width | capacity | airport_id
--- | --- | --- | --- | ---
|  |  |  | (→ Airports.id)
1 | 8000.0 | 100.0 | 9999 | 1
2 | 7000.0 | 150.0 | 9998 | 2
3 | 6000.0 | 120.0 | 9997 | 3
4 | 5000.0 | 90.0 | 9996 | 4
5 | 4000.0 | 80.0 | 9995 | 5

## Flights

id | departure_time | arrival_time | runway_id | plane_model
--- | --- | --- | --- | ---
|  |  | (→ Runways.id) | (→ Planes.model)
1 | 2022-01-01 08:00:00 | 2022-01-01 10:00:00 | 1 | PlaneModel1
2 | 2022-01-02 09:00:00 | 2022-01-02 11:00:00 | 2 | PlaneModel2
3 | 2022-01-03 10:00:00 | 2022-01-03 12:00:00 | 3 | PlaneModel3
4 | 2022-01-04 11:00:00 | 2022-01-04 13:00:00 | 4 | PlaneModel4
5 | 2022-01-05 12:00:00 | 2022-01-05 14:00:00 | 5 | PlaneModel5

## Passengers

id | fullname | passport | flight_id
--- | --- | --- | ---
|  |  | (→ Flights.id)
1 | Passenger1 | Passport1 | 1
2 | Passenger2 | Passport2 | 2
3 | Passenger3 | Passport3 | 3
4 | Passenger4 | Passport4 | 4
5 | Passenger5 | Passport5 | 5