| Airline Name | varchar(255) | Operator name | Airline Contacts | | | |
| Airline ch-a Code | varchar(3) | Operator ch-aviation code (assigned by ch-aviation) | Airline Contacts | Foreign | Airlines | Airline ch-a Code |
| Legal Name | varchar(255) | Operator legal name | Airline Contacts | | | |
| IATA | char(2) | Airline IATA two-character code | Airline Contacts | | | |
| ICAO | char(3) | Airline ICAO three-character code | Airline Contacts | | | |
| Airline Type | varchar(255) | Description of operator’s primary business model (Scheduled Carrier, Virtual Carrier, Division, Cargo Carrier, Business/Private Carrier, Government, Manufacturer, Supplier) | Airline Contacts | | | |
| Airline Type Code | char(1) | Operator type code: S – Scheduled Carrier, V – Virtual Carrier, D – Division, C – Cargo Carrier, B – Business/Private Carrier, G – Government, M – Manufacturer, U – Supplier | Airline Contacts | | | |
| Location | varchar(255) | Location airport name (closest airport if not based at airport itself) | Airline Contacts | | | |
| Location ID | int(11) | Location ID (assigned by ch-aviation) | Airline Contacts | Foreign | Airports | Airport ID |
| Country | varchar(255) | Country name | Airline Contacts | | | |
| Country ISO | char(2) | ISO 3166-1 Alpha-2 country code | Airline Contacts | Foreign | Countries | Country ISO |
| EU Country | char(3) | European Union country: Yes / No / (NULL) | Airline Contacts | | | |
| Title | char(2) | Mr / Ms | Airline Contacts | | | |
| Firstname | varchar(48) | First name | Airline Contacts | | | |
| Lastname | varchar(48) | Last name | Airline Contacts | | | |
| Job Group | varchar(48) | Job Group description (for filtering purposes) | Airline Contacts | | | |
| Job Title | varchar(127) | Job title | Airline Contacts | | | |
| Email | varchar(255) | E-Mail address (masked in sample data) | Airline Contacts | | | |
| Social Media | varchar(255) | Social media URL | Airline Contacts | | | |
