Customers

CustomerIDFirstNameLastNameEmailAddress
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com
3AliceBrownalice.brown@example.com
4CharlieWhitecharlie.white@example.com
5DavidBlackdavid.black@example.com

Flights

FlightNumberDepartureAirportArrivalAirportDepartureTimeEstimatedArrivalTime
1LAXORD2023-01-01 10:00:002023-01-01 18:00:00
2DFWATL2023-01-01 16:00:002023-01-02 09:00:00
3EWRMIA2023-01-01 17:00:002023-01-03 08:00:00
4IAHYYZ2023-01-01 20:00:002023-01-04 15:00:00
5MSPSEA2023-01-01 22:00:002023-01-05 14:00:00

LostProperties

PropertyIDItemDescriptionDateOfLossFound
(→ Calendar.Date)
1Phone2023-01-071
2Keys2023-01-080
3Passport2023-01-091
4Wallet2023-01-060

Complaints

ComplaintIDDescriptionSeverityResolvedSubmissionDateCustomerIdFlightNumber
(→ Calendar.Date)(→ Customers.CustomerID)(→ Flights.FlightNumber)
1Delayed baggage202023-01-0511
2Rude staff312023-01-0622

Calendar

CalendarIDYearMonthDayDate
12023152023-01-05
22023162023-01-06
32023172023-01-07
42023182023-01-08
52023192023-01-09