id | name |
---|---|
1 | AA |
2 | DL |
3 | UA |
id | name |
---|---|
1 | JFK |
2 | LAX |
3 | ORD |
id | airline_id | years_of_experience | role |
---|---|---|---|
(→ Airlines.id) | |||
1 | 1 | 10 | Pilot |
2 | 2 | 3 | None |
3 | 3 | 7 | Co-Pilot |
4 | 4 | 9 | Instructor |
5 | 5 | 6 | Trainee |
6 | 1 | 10 | Aviation Maintenance Technician |
7 | 2 | 8 | Aviation Maintenance Technician |
8 | 1 | 10 | Flight Attendant |
9 | 2 | 7 | Flight Attendant |
id | model | registration_number | current_location_id |
---|---|---|---|
(→ Airports.id) | |||
1 | Boeing 787 | N1234E | 1 |
2 | Airbus A320 | N1235D | 2 |
3 | Embraer E190 | N1236D | 3 |
4 | Bombardier Q400 | N1237C | 4 |
5 | De Havilland Canada DHC-8 | N1238G | 5 |
id | plane_id | departure_time | arrival_time | destination_id | origin_id | pilot_id |
---|---|---|---|---|---|---|
(→ Planes.id) | (→ Airports.id) | (→ Airports.id) | (→ Pilots.id) | |||
1 | 1 | 2023-01-01 10:00:00 | 2023-01-01 12:00:00 | 2 | 1 | 1 |
2 | 2 | 2023-01-02 11:00:00 | 2023-01-02 13:00:00 | 3 | 2 | 2 |
3 | 3 | 2023-01-03 12:00:00 | 2023-01-03 14:00:00 | 4 | 3 | 3 |
4 | 4 | 2023-01-04 13:00:00 | 2023-01-04 15:00:00 | 5 | 4 | 4 |
5 | 5 | 2023-01-05 14:00:00 | 2023-01-05 16:00:00 | 1 | 5 | 5 |