EHDEN / ETL-UK-Biobank

ETL UK-Biobank
https://ehden.github.io/ETL-UK-Biobank/
13 stars 4 forks source link

Run 2021-03-10: Foreign key constraints failing #255

Closed MaximMoinat closed 3 years ago

MaximMoinat commented 3 years ago

Person id, probably due to inconsistent subsetting of the source data.

Unable to add fk_visit_occurrence_person_id_person
Unable to add fk_drug_exposure_person_id_person
Unable to add fk_drug_era_person_id_person

Concept id, probably due to CPT4 vocabulary not loaded.

Unable to add fk_procedure_occurrence_procedure_concept_id_concept
Unable to add fk_observation_value_as_concept_id_concept
Unable to add fk_stem_table_value_as_concept_id_concept

Visit occurrence id, to be investigated. What is the source file of these records?

Unable to add fk_measurement_visit_occurrence_id_visit_occurrence
Unable to add fk_observation_visit_occurrence_id_visit_occurrence
Unable to add fk_stem_table_visit_occurrence_id_visit_occurrence
MaximMoinat commented 3 years ago

Linked to #263, create similar query for these fk failing

MaximMoinat commented 3 years ago

The fk to visit occurrence are very likely fixed with #274. To be verified with next iteration.