Alliances
| Column | Data Type | Data description | Package required | Key | Data Set | Join On |
|---|---|---|---|---|---|---|
| Airline Name | varchar(255) | Operator name | Airlines | |||
| Airline Code | varchar(3) | Operator ch-aviation code (assigned by ch-aviation) | Airlines | Primary | Airlines | Airline ch-a Code |
| Rel Subsidiary | varchar(48) | Regional brand under which the operator operates | Airlines | Primary/Foreign | Regional Subsidiaries | Rel Subsidiary |