| 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 |
| 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 |
| 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 |
| 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 |
| id | FirstName | LastName | LicenseNumber | Rating |
|---|---|---|---|---|
| 1 | John | Doe | P0123456 | ATPL |
| 2 | Jane | Smith | P7890123 | ATPL |
| id | FullName | Age | TicketNumber |
|---|---|---|---|
| 1 | Alice Johnson | 30 | 301 |
| 2 | Bob Smith | 45 | 302 |