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