Cities
Id | Name | Country |
1 | New York | USA |
2 | London | UK |
3 | Paris | France |
4 | Tokyo | Japan |
5 | Dubai | UAE |
Airports
Id | CityId | Code | RunwayCount |
| (→ Cities.Id) | | |
1 | 1 | JFK | 3 |
2 | 2 | LHR | 2 |
3 | 3 | CDG | 2 |
4 | 4 | HND | 4 |
5 | 5 | DXB | 6 |
Runways
Id | Length | Width | SurfaceType | AirportId |
| | | | (→ Airports.Id) |
1 | 9000.0 | 150.0 | Asphalt | 1 |
2 | 8000.0 | 170.0 | Concrete | 2 |
3 | 9500.0 | 200.0 | Grass | 3 |
4 | 8800.0 | 180.0 | Asphalt | 4 |
5 | 12000.0 | 220.0 | Tarmac | 5 |
Flights
FlightId | DepartureAirportId | ArrivalAirportId | ScheduledDeparture | ActualDeparture | EstimatedArrival | Status | AircraftModel |
| (→ Airports.Id) | (→ Airports.Id) | | | | | |
1 | 1 | 2 | 2023-03-25 12:00:00 | 2023-03-25 12:15:00 | 2023-03-25 13:45:00 | On Time | Boeing 747 |
2 | 2 | 3 | 2023-03-25 15:00:00 | 2023-03-25 15:30:00 | 2023-03-25 18:30:00 | Delayed | Airbus A380 |
3 | 3 | 4 | 2023-03-25 18:00:00 | 2023-03-25 18:30:00 | 2023-03-25 22:15:00 | On Time | Boeing 787 |
4 | 4 | 5 | 2023-03-25 21:00:00 | 2023-03-25 21:30:00 | 2023-03-25 23:15:00 | Delayed | Boeing 777 |
5 | 5 | 1 | 2023-03-26 02:00:00 | 2023-03-26 02:30:00 | 2023-03-26 04:15:00 | On Time | Emirates A380 |