Alliances

ColumnData TypeData descriptionPackage requiredKeyData SetJoin On
Airline Namevarchar(255)Operator nameAirlines
Airline Codevarchar(3)Operator ch-aviation code (assigned by ch-aviation)AirlinesPrimaryAirlinesAirline ch-a Code
Rel Subsidiaryvarchar(48)Regional brand under which the operator operatesAirlinesPrimary/ForeignRegional SubsidiariesRel Subsidiary