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