Base ID | int(11) | Unique ch-aviation created base ID | Airline Bases | Primary | | |
Airline Name | varchar(255) | Operator name | Airline Bases | | | |
Airline ch-a Code | char(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Airline Bases | Foreign | Airlines | Airline ch-a Code |
Base IATA | char(3) | Airport three character IATA code | Airline Bases | | | |
Base ICAO | char(4) | Airport four character ICAO code | Airline Bases | | | |
Base Airport ID | int(11) | Location ID (assigned by ch-aviation) | Airline Bases | Foreign | Airports | Airport ID |