| 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 |