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 | | |
flight_number | varchar(4) | Callsign flight number | 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 | | | |