Flight Number Range Decoding
| Column | Data Type | Data description | Key | Data Set | Join On |
| ch_airline_code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Primary/Foreign | Airlines | Airline ch-a Code |
| icao | varchar(3) | Callsign airline ICAO three-character code | Primary | | |
| range_from | varchar(4) | Start of a flight number range | Primary | | |
| range_to | varchar(4) | End of a flight number range | Primary | | |
| suffix | varchar(1) | Callsign suffix | Primary | | |
| flight_type | varchar(20) | Indicator of special flight types (ferry, technical, training) | | | |
| ch_code_regional_partnership | varchar(5) | ch-aviation code for the carrier the regional partnership flights are operated for (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Foreign | Airlines | Airline ch-a Code |
| regional_partnership | varchar(255) | Regional partnership name under which the flight is operated | Foreign | Regional Subsidiaries | Rel Subsidiary |
| ch_code_cargo_customer | varchar(5) | Cargo customer ch-aviation code (assigned by ch-aviation). Can be 2, 3, 4, or 5 characters. | Foreign | Entities | Entity ch-a Code |
| cargo_customer | varchar(255) | Name of cargo customer for whom the flights is operated | | | |
| ch_code_wet_lease_customer | varchar(5) | Wet lease customer ch-aviation code (assigned by ch-aviation). Can be 2, 3, 4, or 5 characters. | Foreign | Entities | Entity ch-a Code |
| wet_lease_customer | varchar(255) | Wet lease customer name | | | |
| notes | varchar(255) | Additional flight description | | | |
