## WeatherConditions

id | Date | Time | Temperature | WindSpeed | FlightStatus
--- | --- | --- | --- | --- | ---
1 | 2023-01-01 | 2023-01-01 12:00:00 | -5.0 | 20.0 | Cancelled
2 | 2023-01-01 | 2023-01-01 18:00:00 | 25.0 | 10.0 | On Schedule

## MechanicalIssues

id | AircraftID | IssueDate | IssueTime | Description | FlightStatus
--- | --- | --- | --- | --- | ---
1 | 1 | 2023-01-01 | 2023-01-01 16:00:00 | Engine malfunction | Cancelled
2 | 2 | 2023-01-01 | 2023-01-01 19:00:00 | Fuel leakage | On Schedule

## Airports

id | Name | Location | IATAChar | ICAOChar
--- | --- | --- | --- | ---
1 | New York John F. Kennedy International Airport | Queens, New York City, NY | JFK | KJFK
2 | Los Angeles International Airport | Los Angeles County, California | LAX | KLAX

## Flights

id | DepartureAirportId | ArrivalAirportId | ScheduledDeparture | ActualDeparture | ScheduledArrival | ActualArrival | FlightNumber
--- | --- | --- | --- | --- | --- | --- | ---
1 | 1 | 2 | 2023-01-01 07:00:00 | 2023-01-01 07:10:00 | 2023-01-01 10:00:00 | 2023-01-01 10:10:00 | 101
2 | 2 | 1 | 2023-01-01 12:00:00 | 2023-01-01 12:10:00 | 2023-01-01 15:00:00 | 2023-01-01 15:10:00 | 202

## Pilots

id | FirstName | LastName | LicenseNumber | Rating
--- | --- | --- | --- | ---
1 | John | Doe | P0123456 | ATPL
2 | Jane | Smith | P7890123 | ATPL

## Passengers

id | FullName | Age | TicketNumber
--- | --- | --- | ---
1 | Alice Johnson | 30 | 301
2 | Bob Smith | 45 | 302