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