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