Aviation_Maintenance_Technicians
id | Name | License_Number | Years_of_experience | Specialization |
1 | John Doe | ABC123 | 10 | Mechanic |
2 | Jane Smith | XYZ789 | 6 | Electrician |
Flight_Attendants
id | Name | License_number | Years_of_experience | Languages_spoken |
1 | Mary Johnson | DEF456 | 10 | English, Spanish |
2 | Bob Brown | GHI780 | 8 | English, French |
Aircrafts
id | Model | Manufacturer | Year_built | Current_status |
1 | Boeing 777 | Boeing | 2000 | In Service |
2 | Airbus A380 | Airbus | 2007 | Retired |
Runways
id | Location | Length | Width | Surface_type |
1 | New York JFK | 10000.0 | 200.0 | Concrete |
2 | Los Angeles LAX | 12000.0 | 250.0 | Asphalt |
Flights
id | Origin_Airport | Destination_airport | Departure_time | Arrival_time | Aircraft_id |
| | | | | (→ Aircrafts.id) |
1 | New York JFK | Los Angeles LAX | 2022-01-01 10:00:00 | 2022-01-01 15:00:00 | 1 |
2 | Los Angeles LAX | New York JFK | 2022-01-02 00:00:00 | 2022-01-02 05:00:00 | 1 |
Maintenance_Records
id | Technician_name | Technician_years_experience | Aircraft_model | Date_of_maintenance | Description |
1 | John Doe | 10 | Boeing 777 | 2022-01-01 | Routine inspection |
2 | Jane Smith | 6 | Airbus A380 | 2022-01-02 | Engine overhaul |