Objective
As a user, I want to define composite foreign keys between data sources
Context
We received new (and final) data from all 4 trees, and we now need composite foreign keys to integrate most of external data.
For instance, for forest inventory external data, for the 'pop' sheet, we need a key between 5 columns at least : proj, year, typ, ecos, loc2.
Same for 'soil sheet: proj, year, loc2, cod.
We will quickly need to support this in order to integrate all4Trees data.
Objective
As a user, I want to define composite foreign keys between data sources
Context
We received new (and final) data from all 4 trees, and we now need composite foreign keys to integrate most of external data.
For instance, for forest inventory external data, for the 'pop' sheet, we need a key between 5 columns at least : proj, year, typ, ecos, loc2.
Same for 'soil sheet: proj, year, loc2, cod.
We will quickly need to support this in order to integrate all4Trees data.