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 |