## Flight

FlightID | DepartureTime | Destination | Duration
--- | --- | --- | ---
1 | 2023-04-01 08:00:00 | New York | 6
2 | 2023-04-01 09:00:00 | Chicago | 7
3 | 2023-04-01 10:00:00 | Los Angeles | 8
4 | 2023-04-01 11:00:00 | Miami | 7
5 | 2023-04-01 12:00:00 | Houston | 6

## Weather

WeatherID | Description | Temperature
--- | --- | ---
1 | Clear Skies | 75.0
2 | Rainy | 65.0
3 | Foggy | 70.0
4 | Stormy | 80.0
5 | Sunny | 85.0

## Mechanical

IssueID | TypeOfIssue | Severity
--- | --- | ---
1 | Engine Trouble | High
2 | Landing Gear Problem | Medium
3 | Electrical System Failure | Low
4 | Brakes Issues | Medium
5 | Fire Extinguisher Missing | High

## Aircraft

AircraftID | Model | Capacity | CurrentAirport
--- | --- | --- | ---
1 | Boeing 747 | 300 | JFK
2 | Airbus A380 | 400 | LAX
3 | Bombardier CRJ700 | 50 | ORD
4 | Embraer E190 | 70 | MIA
5 | Beechcraft King Air C90 | 8 | HOU

## Pilot

PilotID | Name | LicenseNumber | ExperienceYears
--- | --- | --- | ---
1 | John Smith | ABCD1234 | 10
2 | Jane Doe | EFGH5678 | 8
3 | Tom Johnson | IJKL9012 | 5
4 | Emily Williams | LMNOP3456 | 7
5 | David Brown | QRST7890 | 12

## MaintenanceRecord

RecordID | AircraftID | LastMaintenanceDate
--- | --- | ---
| (→ Aircraft.AircraftID) |
1 | 1 | 2022-04-01 00:00:00
2 | 2 | 2021-04-01 00:00:00
3 | 3 | 2022-03-01 00:00:00
4 | 4 | 2021-04-01 00:00:00
5 | 5 | 2022-04-01 00:00:00

## Flight_status

StatusID | FlightID | WeatherID | IssueID | AircraftID | PilotID | RecordID | StatusDescription
--- | --- | --- | --- | --- | --- | --- | ---
| (→ Flight.FlightID) | (→ Weather.WeatherID) | (→ Mechanical.IssueID) | (→ Aircraft.AircraftID) | (→ Pilot.PilotID) | (→ MaintenanceRecord.RecordID) |
1 | 1 | 1 | 1 | 1 | 1 | 1 | Cancelled - Bad Weather & Engine Trouble
2 | 1 | 2 | 2 | 1 | 2 | 2 | Delayed - Rainy & Landing Gear Problem
3 | 2 | 3 | 3 | 2 | 3 | 3 | On Time - Foggy & Electrical System Failure
4 | 3 | 4 | 4 | 3 | 4 | 4 | Cancelled - Stormy & Brakes Issues
5 | 4 | 5 | 5 | 4 | 5 | 5 | Postponed - Sunny & Fire Extinguisher Missing