| Operator Name | varchar(255) | Operator name | Operator Contacts | | | |
| Operator ch-a Code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Operator Contacts | Foreign | Operators | Operator ch-a Code |
| Legal Name | varchar(255) | Operator legal name | Operator Contacts | | | |
| IATA | char(2) | Operator IATA two-character code | Operator Contacts | | | |
| ICAO | char(3) | Operator ICAO three-character code | Operator Contacts | | | |
| Operator Type | varchar(255) | Description of operator's primary business model (Scheduled Carrier, Virtual Carrier, Division, Cargo Carrier, Passenger Charter, Business/Private Charter Government, Manufacturer, Supplier, Private operators, Flight Departments, Ferry Flight Provider) | Operator Contacts | | | |
| Operator Type Code | char(1) | Operator type code: S - Scheduled Carrier, V - Virtual Carrier, D - Division, C - Cargo Carrier, P -Passenger Charter, B - Business/Private Charter, G - Government, M - Manufacturer, U - Supplier, O - Private operators, T - Flight Departments, R - Ferry Flight Provider) | Operator Contacts | | | |
| Operator Status | varchar(255) | Operator status: Active, Start-Up, Restarting, Not Launched, Out of Business, Rebranded, Merged | Operator Contacts | | | |
| Location | varchar(255) | Location airport name (closest airport if not based at airport itself) | Operator Contacts | | | |
| Location ID | int(11) | Location ID (assigned by ch-aviation) | Operator Contacts | Foreign | Airports | Airport ID |
| Country | varchar(255) | Country name | Operator Contacts | | | |
| Country ISO | char(2) | ISO 3166-1 Alpha-2 country code | Operator Contacts | Foreign | Countries | Country ISO |
| EU Country | char(3) | European Union country: Yes / No / (NULL) | Operator Contacts | | | |
| Title | char(2) | Mr / Ms | Operator Contacts | | | |
| Firstname | varchar(48) | First name | Operator Contacts | | | |
| Lastname | varchar(48) | Last name | Operator Contacts | | | |
| Job Group | varchar(48) | Job Group description (for filtering purposes) | Operator Contacts | | | |
| Job Title | varchar(127) | Job title | Operator Contacts | | | |
| Email | varchar(255) | E-Mail address (masked in sample data) | Operator Contacts | | | |
| Social Media | varchar(255) | Social media URL | Operator Contacts | | | |
