id | Name | Navigation_System | Communication_System |
---|---|---|---|
1 | Heathrow | VOR/DME | AMF |
2 | JFK International | ILS | ATIS |
3 | Los Angeles International | NDB/DME | AFIS |
4 | Charles de Gaulle | VOR | FM |
5 | Hong Kong International | DME | ATC |
id | Length | Width | AirportId |
---|---|---|---|
(→ Airport.id) | |||
1 | 3000.0 | 60.0 | 1 |
2 | 2800.0 | 75.0 | 2 |
3 | 3100.0 | 65.0 | 3 |
4 | 2900.0 | 70.0 | 4 |
5 | 3200.0 | 60.0 | 5 |
id | Model | RegistrationNumber | Capacity | HomeAirportId |
---|---|---|---|---|
(→ Airport.id) | ||||
1 | Boeing 747 | G-BNNG | 400 | 1 |
2 | Airbus A380 | N123BA | 450 | 2 |
3 | Boeing 777 | PH-BFD | 350 | 3 |
4 | Airbus A350 | A6-EAE | 300 | 4 |
5 | Bombardier CRJ | N423AW | 50 | 5 |
id | DepartureTime | ArrivalTime | OriginAirportId | DestinationAirportId | AircraftId |
---|---|---|---|---|---|
(→ Airport.id) | (→ Airport.id) | (→ Aircraft.id) | |||
1 | 2022-01-01 10:00:00 | 2022-01-01 13:00:00 | 1 | 2 | 1 |
2 | 2022-01-01 11:00:00 | 2022-01-01 14:00:00 | 2 | 1 | 2 |
3 | 2022-01-01 12:00:00 | 2022-01-01 15:00:00 | 3 | 4 | 3 |
4 | 2022-01-01 13:00:00 | 2022-01-01 16:00:00 | 4 | 3 | 4 |
5 | 2022-01-01 14:00:00 | 2022-01-01 17:00:00 | 5 | 2 | 5 |
id | Description | StartDate | EndDate | AircraftId |
---|---|---|---|---|
(→ Aircraft.id) | ||||
1 | Engine check | 2022-01-01 08:00:00 | 2022-01-01 12:00:00 | 1 |
2 | Landing gear inspection | 2022-01-01 13:00:00 | 2022-01-01 17:00:00 | 2 |
3 | Brake system check | 2022-01-01 18:00:00 | 2022-01-01 22:00:00 | 3 |
4 | Avionics test | 2022-01-01 23:00:00 | 2022-01-02 03:00:00 | 4 |
5 | Tire rotation and balance | 2022-01-02 04:00:00 | 2022-01-02 08:00:00 | 5 |