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
(→ PropertiesCalendar.Date)
1Laptop2023-01-051
2Wallet2023-01-060
3Phone2023-01-071
4Keys2023-01-080
5Passport2023-01-091

Complaints

ComplaintIDDescriptionSeverityResolvedSubmissionDateCustomerIdFlightNumber
(→ PropertiesCalendar.Date)(→ Customers.CustomerID)(→ Flights.FlightNumber)
1Delayed baggage202023-01-0511
2Rude staff302023-01-0622
3Food poisoning302023-01-0733
4Seat comfort102023-01-0844
5Noise202023-01-0955

PropertiesCalendar

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