Problem
The cohort_definition_id field in the cohort_definition table is not marked as a primary key in the CSV spec files for v5.3 and v5.4, even though it is the natural primary key for that table (each cohort definition has a unique ID). The v6.0 CSV correctly marks it as a primary key.
Affected Files
inst/csv/OMOP_CDMv5.3_Field_Level.csv — cohort_definition,cohort_definition_id has isPrimaryKey=Noinst/csv/OMOP_CDMv5.4_Field_Level.csv — same issuedocs/cdm53.html — generated HTML shows Primary Key=Nodocs/cdm54.html — generated HTML shows Primary Key=No
Proposed Fix
Change isPrimaryKey from No to Yes for the cohort_definition_id field in the cohort_definition table in both v5.3 and v5.4 CSV files, and update the generated HTML docs accordingly.
Problem
The
cohort_definition_idfield in thecohort_definitiontable is not marked as a primary key in the CSV spec files for v5.3 and v5.4, even though it is the natural primary key for that table (each cohort definition has a unique ID). The v6.0 CSV correctly marks it as a primary key.Affected Files
inst/csv/OMOP_CDMv5.3_Field_Level.csv—cohort_definition,cohort_definition_idhasisPrimaryKey=Noinst/csv/OMOP_CDMv5.4_Field_Level.csv— same issuedocs/cdm53.html— generated HTML shows Primary Key=Nodocs/cdm54.html— generated HTML shows Primary Key=NoProposed Fix
Change
isPrimaryKeyfromNotoYesfor thecohort_definition_idfield in thecohort_definitiontable in both v5.3 and v5.4 CSV files, and update the generated HTML docs accordingly.