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 |