Flights
flightID | originAirportID | destinationAirportID | departureDate | arrivalDate | flightCategory | boardingTime |
| (→ Airports.airportID) | (→ Airports.airportID) | | | | |
1 | 1 | 2 | 2023-07-18 09:00 | 2023-07-18 16:00 | International Flight | 10:00 |
2 | 1 | 3 | 2023-07-19 08:00 | 2023-07-19 15:00 | International Flight | 09:30 |
3 | 1 | 2 | 2023-07-20 09:00 | 2023-07-20 16:00 | Domestic Flight | 10:00 |
4 | 4 | 5 | 2023-07-21 08:00 | 2023-07-21 15:00 | Domestic Flight | 10:30 |
5 | 1 | 6 | 2023-07-22 10:00 | 2023-07-22 17:00 | Regional Flight | 09:30 |
6 | 2 | 3 | 2023-07-23 09:00 | 2023-07-23 16:00 | Charter Flight | 11:00 |
7 | 3 | 1 | 2023-07-24 08:00 | 2023-07-24 15:00 | Private Jet | 12:00 |
Passengers
passengerID | fullName | dateOfBirth |
1 | John Doe | 1990-01-01 |
2 | Jane Smith | 1985-06-15 |
3 | Michael Johnson | 2000-09-03 |
4 | Emily Davis | 1992-10-20 |
5 | David Brown | 1988-12-05 |
Planes
planeID | model | capacity |
1 | Boeing 747 | 400 |
2 | Airbus A380 | 800 |
3 | Embraer E195 | 110 |
4 | Bombardier CRJ700 | 65 |
5 | Gulfstream G650 | 15 |
StaffMembers
staffMemberID | firstName | lastName | position |
1 | Alice | Adams | Pilot |
2 | Bob | Smith | Co-pilot |
3 | Carol | Johnson | Customer Service Agent |
4 | Dave | Williams | Manager |
5 | Eva | Jones | Maintenance Technician |
Bookings
bookingID | flightID | passengerID | bookedByStaffMemberID | bookedAt |
| (→ Flights.flightID) | (→ Passengers.passengerID) | (→ StaffMembers.staffMemberID) | |
1 | 1 | 1 | 1 | 2024-03-07 22:47:19 |
2 | 2 | 2 | 1 | 2024-03-07 22:47:19 |
3 | 3 | 3 | 2 | 2024-03-07 22:47:19 |
4 | 4 | 4 | 3 | 2024-03-07 22:47:19 |
5 | 5 | 5 | 4 | 2024-03-07 22:47:19 |
Assignments
assignmentID | planeID | assignedToStaffMemberID | startDateTime | endDateTime |
| (→ Planes.planeID) | (→ StaffMembers.staffMemberID) | | |
1 | 1 | 1 | 2023-07-22 07:00 | 2023-07-22 16:00 |
2 | 2 | 2 | 2023-07-23 06:00 | 2023-07-23 15:00 |
3 | 3 | 3 | 2023-07-24 05:00 | 2023-07-24 14:00 |
4 | 4 | 4 | 2023-07-25 06:00 | 2023-07-25 15:00 |
5 | 5 | 5 | 2023-07-26 05:00 | 2023-07-26 14:00 |