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

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

https://github.com/OHDSI/CommonDataModel/blob/d83d48c2ba1b641879c33958903f630318421cb8/inst/csv/OMOP_CDMv5.3_Field_Level.csv#L504

5.4

https://github.com/OHDSI/CommonDataModel/blob/d83d48c2ba1b641879c33958903f630318421cb8/inst/csv/OMOP_CDMv5.4_Field_Level.csv#L545

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?

https://github.com/OHDSI/CommonDataModel/blob/d83d48c2ba1b641879c33958903f630318421cb8/inst/csv/OMOP_CDMv6.0_Field_Level.csv#L541

Start by inspecting the referenced rows in inst/csv/OMOP_CDMv5.3_Field_Level.csv, OMOP_CDMv5.4_Field_Level.csv, and OMOP_CDMv6.0_Field_Level.csv, then compare the cohort_definition and cohort key definitions. Done means the primary-key and foreign-key metadata consistently represents the relationship described in the issue across the affected CDM versions.