## Flights

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

## Passengers

passengerID | firstName | lastName | dateOfBirth | gender | email | 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

## Unaccompanied_Minors

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

## Special_Needs_Passengers

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

## Staff

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