FlightID | DepartureTime | Destination | AircraftID |
---|---|---|---|
(→ Aircraft.AircraftID) | |||
1 | 10:00 | New York | 1 |
2 | 12:00 | Los Angeles | 2 |
3 | 14:00 | Chicago | 3 |
4 | 16:00 | Dallas | 4 |
5 | 18:00 | Atlanta | 5 |
PassengerID | Name | Age |
---|---|---|
1 | John Doe | 35 |
2 | Jane Smith | 27 |
3 | Alice Johnson | 43 |
4 | Bob Brown | 56 |
5 | Emma Wilson | 29 |
AircraftID | Model | Capacity |
---|---|---|
1 | Boeing 737 | 160 |
2 | Airbus A320 | 180 |
3 | Embraer E190 | 100 |
4 | Bombardier CRJ700 | 70 |
5 | Cessna Citation XLS+ | 8 |
StaffID | FirstName | LastName | Role |
---|---|---|---|
1 | Tom | Hanks | Pilot |
2 | Robert | Downey Jr. | Co-pilot |
3 | Keira | Knightley | Flight Attendant |
4 | Mark | Ruffalo | Ground Staff |
5 | Scarlett | Johansson | Customer Service |
MobilityAidID | Type | Available |
---|---|---|
1 | Wheelchair Assistance | 1 |
2 | Mobility Scooter | 0 |
3 | Portable Oxygen Concentrator | 1 |
4 | Walking Sticks | 1 |
5 | Electric Wheelchairs | 0 |
LocationID | Description | IsPickUpDropOff |
---|---|---|
1 | Entrance A | 1 |
2 | Gate B | 0 |
3 | Gate C | 0 |
4 | Curbside Check-in | 1 |
5 | Security Checkpoint | 0 |
ServiceID | MobilityAidID | LocationID |
---|---|---|
(→ MobilityAids.MobilityAidID) | (→ Locations.LocationID) | |
1 | 1 | 1 |
2 | 1 | 2 |
3 | 2 | 1 |
4 | 2 | 2 |
5 | 3 | 1 |