Priority_Boarding
id | Airline | FlightNumber | DepartureTime | Destination |
1 | Alaskan Airlines | AA101 | 2023-06-07 08:00:00 | Los Angeles |
2 | United Airlines | UA999 | 2023-06-07 09:00:00 | New York |
Family_Boarding
id | Airline | FlightNumber | DepartureTime | Destination |
1 | Alaskan Airlines | AS101 | 2023-06-08 10:00:00 | Honolulu |
2 | Delta Airlines | DL888 | 2023-06-08 11:00:00 | Atlanta |
PassengerInfo
id | FirstName | LastName | Age | Nationality |
1 | John | Doe | 30 | USA |
2 | Jane | Smith | 25 | UK |
StaffInfo
id | Role | Name | Experience |
1 | Pilot | Captain Jones | 10 |
2 | Cabin Crew | Flight Attendant Smith | 5 |
PlaneInfo
id | Model | Capacity | MaintainedDate |
1 | Boeing 737 | 200 | 2023-05-01 |
2 | Airbus A320 | 180 | 2023-05-02 |
BaggageInfo
id | Weight | Type | OwnerId |
| | | (→ PassengerInfo.id) |
1 | 10 | Luggage | 1 |
2 | 5 | Carry On | 2 |