Field `cohort_definition_id` in table `cohort_definition` should be a primary key.

[lgautier]

The field cohort_definition_id in table cohort_definition should be a primary key. The issue is present with version 5.3, and 5.4 (see below), and version 6.0 might introduce another issue (see further below).

5.3

CommonDataModel/inst/csv/OMOP_CDMv5.3_Field_Level.csv

Line 504 in d83d48c

cohort_definition,cohort_definition_id,Yes,integer,"This is the identifier given to the cohort, usually by the ATLAS application",NA,No,No,NA,NA,NA,NA,NA

5.4

CommonDataModel/inst/csv/OMOP_CDMv5.4_Field_Level.csv

Line 545 in d83d48c

cohort_definition,cohort_definition_id,Yes,integer,"This is the identifier given to the cohort, usually by the ATLAS application",NA,No,No,NA,NA,NA,NA,NA

6.0

Version 6.0 indicates that cohort_definition_id is a foreign key from the field/column cohort_definition_id in table table cohort (where it is not a primary key). Should it be the other way around (field/column cohort_definition_id in table table cohort is a foreign key from cohort_definition.cohort_definition_id?

CommonDataModel/inst/csv/OMOP_CDMv6.0_Field_Level.csv

Line 541 in d83d48c

cohort_definition,cohort_definition_id,Yes,integer,"This is the identifier given to the cohort, usually by the ATLAS application",NA,No,Yes,COHORT,COHORT_DEFINITION_ID,NA,NA,NA