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 |