Contact ID |
int(11) |
Unique ch-aviation created contact ID |
Airline Contacts |
Primary |
|
|
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 |
|
|
|