OHDSI Home | Forums | Wiki | Github

SQL server v5.3.1 OMOP CDM sql server constraints - invalid file

Against tag 5.3.1 in sql_server, line 184 of ‘OMOP CDM sql server constraints.txt’ has a rogue space making it invalid:
ALTER TABLE visit_occurrence ADD CONSTRAINT fpk_ visit_concept_s FOREIGN KEY (visit_source_concept_id) REFERENCES concept (concept_id);

This issue has been resolved on the master branch, although v5.3.1 is the latest stable release to accept a vocabulary. My github knowledge is limited - could a valid constraints file be tagged for v5.3.1.

Philip

t