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 |
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 |
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 |
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 |