ID | Item | FoundAt | Description | Date |
---|---|---|---|---|
1 | Wristwatch | Gate A1 | Silver wristwatch with black leather strap | January 5, 2024 |
2 | Mobile Phone | Food Court | iPhone X with a cracked screen | December 31, 2023 |
ComplaintID | CustomerName | FlightNumber | Issue | Resolution | Date |
---|---|---|---|---|---|
1 | John Doe | AA123 | Late boarding | Apologized and provided meal voucher | January 5, 2024 |
2 | Jane Smith | DL456 | Luggage mishandled | Delivered luggage within two hours | December 30, 2023 |
FlightNumber | Airline | DepartureTime | ArrivalTime | OriginAirport | DestinationAirport |
---|---|---|---|---|---|
AA123 | American Airlines | 08:00 AM | 10:00 AM | LAX | ORD |
DL456 | Delta Airlines | 09:00 AM | 11:00 AM | ATL | MCO |
Registration | Model | Manufacturer | YearOfManufacture | SeatCapacity |
---|---|---|---|---|
N123AB | Boeing 737-800 | Boeing | 2010 | 160 |
N345CD | Airbus A320 | Airbus | 2012 | 180 |
EmployeeID | FirstName | LastName | JobTitle | HireDate |
---|---|---|---|---|
1 | Alice | Smith | Security Officer | October 1, 2022 |
2 | Bob | Johnson | Pilot | September 1, 2022 |