Define the primary keys and their type for all models
We need to define the primary keys and their type for all models:
- header
- observation
- instrument
- instrument_mode
- interferometer
- ...
Currently, we use either:
- String/Unicode value
- Integer
- UUID
Remarks:
- Keys based on string values do not provide enough unicity
- Integer keys are agnostic but may have gaps due to rollback operations
- UUID keys are agnostic and may be computed to be predictive
On some models, the primary key may be composite: