## Airlines

id | name
--- | ---
1 | Airline A
2 | Airline B

## Airports

id | name | city | country | code
--- | --- | --- | --- | ---
1 | Airport X | City Z | Country Y | XYZ
2 | Airport W | City V | Country U | WVU

## Flights

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

## Flight_Disruptions

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

## Flight_Statuses

id | flight_id | status
--- | --- | ---
| (→ Flights.id) |
1 | 1 | Delayed
2 | 2 | Cancelled