flightID | originAirport | destinationAirport | departureTime | arrivalTime | aircraftType | passengerCount |
---|---|---|---|---|---|---|
1 | JFK | LAX | 2023-03-01 07:00:00 | 2023-03-01 16:00:00 | Boing 787 | 300 |
2 | ORD | SEA | 2023-03-01 09:00:00 | 2023-03-01 18:00:00 | Airbus A320 | 250 |
3 | DFW | IAD | 2023-03-01 11:00:00 | 2023-03-01 20:00:00 | Boeing 737 | 275 |
4 | YVR | MCO | 2023-03-01 13:00:00 | 2023-03-01 22:00:00 | Embraer E190 | 220 |
5 | PEK | LHR | 2023-03-01 05:00:00 | 2023-03-01 13:00:00 | Air China A330 | 310 |
passengerID | firstName | lastName | dateOfBirth | gender | phoneNumber | |
---|---|---|---|---|---|---|
1 | John | Doe | 1990-01-01 | M | john.doe@example.com | +1 555-123-4567 |
2 | Jane | Smith | 1985-02-01 | F | jane.smith@example.com | +1 555-987-6543 |
3 | Alice | Johnson | 1992-03-01 | F | alice.johnson@example.com | +1 555-654-3219 |
4 | Bob | Williams | 1988-04-01 | M | bob.williams@example.com | +1 555-456-7890 |
5 | Charlie | Brown | 1993-05-01 | M | charlie.brown@example.com | +1 555-123-4567 |
minorID | passengerID | unaccompaniedBy | contactInfo | assistant |
---|---|---|---|---|
(→ Passengers.None) | ||||
1 | 1 | None | None | Clare Allen |
2 | 2 | David Johnson | +1 555-000-0000 | Sam Smith |
3 | 3 | Emily Davis | +1 555-111-2222 | Nancy Jones |
4 | 4 | Jack Miller | +1 555-333-4444 | Paul Thompson |
5 | 5 | Lucy Garcia | +1 555-555-6666 | Rachel Brown |
needsID | passengerID | specialNeedDescription | additionalInstructions | assistant |
---|---|---|---|---|
(→ Passengers.None) | ||||
1 | 1 | Wheelchair assistance required. | Please assist with boarding. | Clare Allen |
2 | 2 | Hearing impairment. | Use sign language when communicating. | Carol White |
3 | 3 | Visual impairment. | Offer verbal guidance during boarding and deplaning. | Tom Harris |
4 | 4 | Diabetes. | Ensure snacks and insulin are available onboard. | Michael Green |
5 | 5 | Allergic to peanuts. | No peanuts should be served on this flight. | Laura King |
staffID | firstName | lastName | role | hireDate |
---|---|---|---|---|
1 | James | Smith | Pilot | 2020-06-01 |
2 | Anna | Martin | Cabin Crew | 2019-08-01 |
3 | Steve | Garner | Maintenance Engineer | 2021-09-01 |
4 | Helen | Price | Customer Service Representative | 2022-10-01 |
5 | Mark | Taylor | Security Officer | 2023-01-01 |