Spire-ch-aviation Mapping
| Column | Data Type | Data description | Key | Data Set | Join On |
| flight_id | varchar(255) | Spire internal unique flight ID. Random UUIDv4 sequence | Primary/foreign | Flights | flight_id |
| flight_type | varchar(20) | Indicator of special flight types (ferry, technical, training) | | | |
| regional_partnership | varchar(255) | Regional partnership name under which the flight is operated | Foreign | Regional Subsidiaries | Rel Subsidiary |
| cargo_customer | varchar(255) | Name of cargo customer for whom the flights is operated | | | |
| wet_lease_customer | varchar(255) | Wet lease customer name | | | |
| notes | varchar(255) | Additional free text notes related to the flight | | | |
| aircraft_id | int4 | Unique ch-aviation created aircraft ID, remains stable throughout an aircraft's life (assigned by ch-aviation), the aircraft_id and date_from_full fields are the combined primary key of the Aircraft Histories data set | Foreign (Combined) | Aircraft Histories | Aircraft ID |
| date_from_full | date | From date with operator, registration and variant, the aircraft_id and date_from_full fields are the combined primary key of the Aircraft Histories data set | Foreign (Combined) | Aircraft Histories | Date From Full |
