flightID | origin | destination | departureTime | arrivalTime |
---|---|---|---|---|
1 | LAX | JFK | 2021-09-01 08:30:00 | 2021-09-01 17:00:00 |
2 | ORD | ATL | 2021-09-01 12:30:00 | 2021-09-01 19:00:00 |
passengerID | firstName | lastName | passportNumber | age |
---|---|---|---|---|
1 | John | Doe | ABC123456 | 28 |
2 | Jane | Smith | XYZ789012 | 34 |
aircraftID | model | capacity |
---|---|---|
1 | Boeing 787 | 300 |
2 | Airbus A380 | 500 |
terminalID | name |
---|---|
1 | Terminal 1 |
2 | Terminal 2 |
accessibilityServiceId | serviceName | description |
---|---|---|
1 | Assisted Transportation | Transportation assistance for passengers with disabilities. |
2 | TTY Services | Telecommunications relay services for deaf or hard of hearing passengers. |
amenityServiceId | serviceName | description | Passenger_Amenities | Accessibility |
---|---|---|---|---|
1 | Airport Lounge | Relaxing area for passengers. | Airport Lounge | Wheelchair Users |
2 | Airport Lounge | Relaxing area for passengers. | Airport Lounge | Not Wheelchair Users |
3 | Observation Deck | Viewing platform for planes taking off and landing. | Observation Deck | Wheelchair Users |
4 | Observation Deck | Viewing platform for planes taking off and landing. | Observation Deck | Not Wheelchair Users |