Boeing
id | Model | Number_of_seats | Manufacture_year | LastMaintenanceDate |
1 | 737 | 180 | 2000 | 2022-06-01 |
2 | 747 | 400 | 1990 | 2021-09-01 |
Airbus
id | Model | Number_of_seats | Manufacture_year | LastMaintenanceDate |
1 | A320 | 180 | 2010 | 2022-07-01 |
2 | A380 | 800 | 2007 | 2021-12-01 |
Flight
id | airplaneId | departureTime | arrivalTime | destination |
| (→ Airbus.id) | | | |
1 | 1 | 2022-08-01 08:00:00 | 2022-08-01 12:00:00 | New York |
2 | 2 | 2022-08-02 09:00:00 | 2022-08-02 13:00:00 | Los Angeles |
Pilot
id | name | licenseNumber | experienceYears |
1 | John Doe | ABC1234 | 10 |
2 | Jane Smith | XYZ7890 | 15 |
Maintenance
id | airplaneId | maintenanceType | datePerformed | technicianName |
| (→ Airbus.id) | | | |
1 | 1 | Engine Overhaul | 2021-05-01 | Mike Brown |
2 | 2 | Landing Gear Repair | 2021-06-01 | Lisa Johnson |