id | name |
---|---|
1 | Airline A |
2 | Airline B |
id | name | city | country | code |
---|---|---|---|---|
1 | Airport X | City Z | Country Y | XYZ |
2 | Airport W | City V | Country U | WVU |
id | departure_airport_id | arrival_airport_id | airline_id | scheduled_departure | actual_departure | scheduled_arrival | actual_arrival | flight_number |
---|---|---|---|---|---|---|---|---|
(→ Airports.id) | (→ Airports.id) | (→ Airlines.id) | ||||||
1 | 1 | 2 | 1 | 2023-01-01 10:00:00 | 2023-01-01 10:30:00 | 2023-01-01 11:00:00 | 2023-01-01 11:30:00 | AA123 |
2 | 2 | 1 | 2 | 2023-01-02 10:00:00 | 2023-01-02 10:30:00 | 2023-01-02 11:00:00 | 2023-01-02 11:30:00 | BB456 |
id | flight_id | disruption_type | description |
---|---|---|---|
(→ Flights.id) | |||
1 | 1 | Weather Condition | Heavy rain caused a delay |
2 | 2 | Weather Condition | Foggy weather led to cancellation |
3 | 1 | Mechanical Issue | Engine issue caused a delay |
4 | 2 | Mechanical Issue | Brake failure resulted in cancellation |
id | flight_id | status |
---|---|---|
(→ Flights.id) | ||
1 | 1 | Delayed |
2 | 2 | Cancelled |