CountryID | Name |
---|---|
1 | USA |
2 | UK |
3 | France |
4 | Germany |
5 | Japan |
CityID | Name | CountryId |
---|---|---|
(→ Countries.CountryID) | ||
1 | New York | 1 |
2 | London | 2 |
3 | Paris | 3 |
4 | Berlin | 4 |
5 | Tokyo | 5 |
AirportId | Name | CityId | Structure | RunwayLength |
---|---|---|---|---|
(→ Cities.CityID) | ||||
1 | JFK International | 1 | Terminal Building | 9000.0 |
2 | Heathrow Airport | 2 | Terminal Building | 8000.0 |
3 | Charles de Gaulle Airport | 3 | Terminal Building | 6000.0 |
4 | Tegel Airport | 4 | Cargo Terminal | 4000.0 |
5 | Haneda Airport | 5 | Terminal Building | 8500.0 |
FlightId | SourceAirportId | DestinationAirportId | DepartureTime | ArrivalTime | AircraftId |
---|---|---|---|---|---|
(→ Airports.AirportId) | (→ Airports.AirportId) | (→ Planes.PlaneId) | |||
1 | 1 | 2 | 2022-01-01 08:00:00 | 2022-01-01 12:00:00 | 1 |
2 | 2 | 1 | 2022-01-02 08:00:00 | 2022-01-02 12:00:00 | 1 |
3 | 3 | 4 | 2022-01-03 08:00:00 | 2022-01-03 12:00:00 | 2 |
4 | 4 | 3 | 2022-01-04 08:00:00 | 2022-01-04 12:00:00 | 2 |
5 | 5 | 5 | 2022-01-05 08:00:00 | 2022-01-05 12:00:00 | 3 |
PlaneId | Model | Seats |
---|---|---|
1 | Boeing 747 | 400 |
2 | Airbus A380 | 800 |
3 | Bombardier CRJ1000 | 100 |
RunwayId | Length | Width | AirportId |
---|---|---|---|
(→ Airports.AirportId) | |||
1 | 10000.0 | 150.0 | 1 |
2 | 9000.0 | 150.0 | 2 |
3 | 7000.0 | 150.0 | 3 |
4 | 6000.0 | 150.0 | 4 |
5 | 9500.0 | 150.0 | 5 |