Airline Bases

Column Data Type Data description Package required Key Data Set Join On
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(3) Operator ch-aviation code (assigned by ch-aviation) 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