Regional Subsidiaries
| Column | Data Type | Data description | Package required | Key | Data Set | Join On |
|---|---|---|---|---|---|---|
| Rel Subsidiary | varchar(48) | Regional brand name | Airlines | Primary | Regional Carriers | Rel Subsidiary |
| Parent Carrier | varchar(255) | Parent name | Airlines | |||
| Parent Carrier ch-a Code | varchar(3) | Parent operator ch-aviation code (assigned by ch-aviation) | Airlines | Primary/Foreign | Airlines | Airline ch-a Code |