## Airports

id | name | city | country
--- | --- | --- | ---
1 | New York JFK | New York | USA
2 | London Heathrow | London | UK
3 | Tokyo Haneda | Tokyo | Japan
4 | Dubai International | Dubai | UAE
5 | Frankfurt Airport | Frankfurt | Germany

## Flights

flightNumber | departureAirportId | arrivalAirportId | departureTime | arrivalTime
--- | --- | --- | --- | ---
| (→ Airports.id) | (→ Airports.id) |  |
1 | 1 | 2 | 2023-06-01 10:00:00 | 2023-06-01 18:00:00
2 | 3 | 4 | 2023-07-01 12:00:00 | 2023-07-01 20:00:00
3 | 5 | 2 | 2023-08-01 14:00:00 | 2023-08-01 22:00:00
4 | 3 | 5 | 2023-09-01 16:00:00 | 2023-09-01 23:00:00
5 | 1 | 4 | 2023-10-01 08:00:00 | 2023-10-01 16:00:00

## Passengers

passengerId | firstName | lastName | dateOfBirth | isMinor
--- | --- | --- | --- | ---
1 | John | Doe | 1990-01-01 | 1
2 | Jane | Smith | 1985-02-02 | 0
3 | Emily | Johnson | 1991-03-03 | 1
4 | Michael | Williams | 1988-04-04 | 0
5 | David | Brown | 1992-05-05 | 1

## SpecialRequirements

requirementId | description | assistant
--- | --- | ---
1 | Wheelchair assistance required | Alice Brown
2 | Oxygen tank needed on board | Bob Johnson
3 | Diabetic meal request | Charlie White
4 | Special dietary needs | Daniel Green
5 | Hearing aid support | Eva Black
6 | Unaccompanied Minor | Clare Allen
7 | Unaccompanied Minor | Mark Taylor
8 | Special Needs Passenger | Clare Allen
9 | Special Needs Passenger | Nancy Davis