Skip to content

C
CDM-OMOP
Switch branch/tag
Find file Normal viewHistoryPermalink
omop_constraints_postgres.sql 27.1 KB
Newer Older
Pepe Marquez's avatar
instancia de omop en postgres  
Pepe Marquez committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 
--postgresql CDM Foreign Key Constraints for OMOP Common Data Model 5.4

ALTER TABLE omop.PERSON ADD CONSTRAINT fpk_PERSON_gender_concept_id FOREIGN KEY (gender_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PERSON ADD CONSTRAINT fpk_PERSON_race_concept_id FOREIGN KEY (race_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PERSON ADD CONSTRAINT fpk_PERSON_ethnicity_concept_id FOREIGN KEY (ethnicity_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PERSON ADD CONSTRAINT fpk_PERSON_location_id FOREIGN KEY (location_id) REFERENCES omop.LOCATION (LOCATION_ID);

ALTER TABLE omop.PERSON ADD CONSTRAINT fpk_PERSON_provider_id FOREIGN KEY (provider_id) REFERENCES omop.PROVIDER (PROVIDER_ID);

ALTER TABLE omop.PERSON ADD CONSTRAINT fpk_PERSON_care_site_id FOREIGN KEY (care_site_id) REFERENCES omop.CARE_SITE (CARE_SITE_ID);

ALTER TABLE omop.PERSON ADD CONSTRAINT fpk_PERSON_gender_source_concept_id FOREIGN KEY (gender_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PERSON ADD CONSTRAINT fpk_PERSON_race_source_concept_id FOREIGN KEY (race_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PERSON ADD CONSTRAINT fpk_PERSON_ethnicity_source_concept_id FOREIGN KEY (ethnicity_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.OBSERVATION_PERIOD ADD CONSTRAINT fpk_OBSERVATION_PERIOD_person_id FOREIGN KEY (person_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.OBSERVATION_PERIOD ADD CONSTRAINT fpk_OBSERVATION_PERIOD_period_type_concept_id FOREIGN KEY (period_type_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.VISIT_OCCURRENCE ADD CONSTRAINT fpk_VISIT_OCCURRENCE_person_id FOREIGN KEY (person_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.VISIT_OCCURRENCE ADD CONSTRAINT fpk_VISIT_OCCURRENCE_visit_concept_id FOREIGN KEY (visit_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.VISIT_OCCURRENCE ADD CONSTRAINT fpk_VISIT_OCCURRENCE_visit_type_concept_id FOREIGN KEY (visit_type_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.VISIT_OCCURRENCE ADD CONSTRAINT fpk_VISIT_OCCURRENCE_provider_id FOREIGN KEY (provider_id) REFERENCES omop.PROVIDER (PROVIDER_ID);

ALTER TABLE omop.VISIT_OCCURRENCE ADD CONSTRAINT fpk_VISIT_OCCURRENCE_care_site_id FOREIGN KEY (care_site_id) REFERENCES omop.CARE_SITE (CARE_SITE_ID);

ALTER TABLE omop.VISIT_OCCURRENCE ADD CONSTRAINT fpk_VISIT_OCCURRENCE_visit_source_concept_id FOREIGN KEY (visit_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.VISIT_OCCURRENCE ADD CONSTRAINT fpk_VISIT_OCCURRENCE_admitted_from_concept_id FOREIGN KEY (admitted_from_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.VISIT_OCCURRENCE ADD CONSTRAINT fpk_VISIT_OCCURRENCE_discharged_to_concept_id FOREIGN KEY (discharged_to_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.VISIT_OCCURRENCE ADD CONSTRAINT fpk_VISIT_OCCURRENCE_preceding_visit_occurrence_id FOREIGN KEY (preceding_visit_occurrence_id) REFERENCES omop.VISIT_OCCURRENCE (VISIT_OCCURRENCE_ID);

ALTER TABLE omop.VISIT_DETAIL ADD CONSTRAINT fpk_VISIT_DETAIL_person_id FOREIGN KEY (person_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.VISIT_DETAIL ADD CONSTRAINT fpk_VISIT_DETAIL_visit_detail_concept_id FOREIGN KEY (visit_detail_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.VISIT_DETAIL ADD CONSTRAINT fpk_VISIT_DETAIL_visit_detail_type_concept_id FOREIGN KEY (visit_detail_type_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.VISIT_DETAIL ADD CONSTRAINT fpk_VISIT_DETAIL_provider_id FOREIGN KEY (provider_id) REFERENCES omop.PROVIDER (PROVIDER_ID);

ALTER TABLE omop.VISIT_DETAIL ADD CONSTRAINT fpk_VISIT_DETAIL_care_site_id FOREIGN KEY (care_site_id) REFERENCES omop.CARE_SITE (CARE_SITE_ID);

ALTER TABLE omop.VISIT_DETAIL ADD CONSTRAINT fpk_VISIT_DETAIL_visit_detail_source_concept_id FOREIGN KEY (visit_detail_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.VISIT_DETAIL ADD CONSTRAINT fpk_VISIT_DETAIL_admitted_from_concept_id FOREIGN KEY (admitted_from_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.VISIT_DETAIL ADD CONSTRAINT fpk_VISIT_DETAIL_discharged_to_concept_id FOREIGN KEY (discharged_to_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.VISIT_DETAIL ADD CONSTRAINT fpk_VISIT_DETAIL_preceding_visit_detail_id FOREIGN KEY (preceding_visit_detail_id) REFERENCES omop.VISIT_DETAIL (VISIT_DETAIL_ID);

ALTER TABLE omop.VISIT_DETAIL ADD CONSTRAINT fpk_VISIT_DETAIL_parent_visit_detail_id FOREIGN KEY (parent_visit_detail_id) REFERENCES omop.VISIT_DETAIL (VISIT_DETAIL_ID);

ALTER TABLE omop.VISIT_DETAIL ADD CONSTRAINT fpk_VISIT_DETAIL_visit_occurrence_id FOREIGN KEY (visit_occurrence_id) REFERENCES omop.VISIT_OCCURRENCE (VISIT_OCCURRENCE_ID);

ALTER TABLE omop.CONDITION_OCCURRENCE ADD CONSTRAINT fpk_CONDITION_OCCURRENCE_person_id FOREIGN KEY (person_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.CONDITION_OCCURRENCE ADD CONSTRAINT fpk_CONDITION_OCCURRENCE_condition_concept_id FOREIGN KEY (condition_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.CONDITION_OCCURRENCE ADD CONSTRAINT fpk_CONDITION_OCCURRENCE_condition_type_concept_id FOREIGN KEY (condition_type_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.CONDITION_OCCURRENCE ADD CONSTRAINT fpk_CONDITION_OCCURRENCE_condition_status_concept_id FOREIGN KEY (condition_status_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.CONDITION_OCCURRENCE ADD CONSTRAINT fpk_CONDITION_OCCURRENCE_provider_id FOREIGN KEY (provider_id) REFERENCES omop.PROVIDER (PROVIDER_ID);

ALTER TABLE omop.CONDITION_OCCURRENCE ADD CONSTRAINT fpk_CONDITION_OCCURRENCE_visit_occurrence_id FOREIGN KEY (visit_occurrence_id) REFERENCES omop.VISIT_OCCURRENCE (VISIT_OCCURRENCE_ID);

ALTER TABLE omop.CONDITION_OCCURRENCE ADD CONSTRAINT fpk_CONDITION_OCCURRENCE_visit_detail_id FOREIGN KEY (visit_detail_id) REFERENCES omop.VISIT_DETAIL (VISIT_DETAIL_ID);

ALTER TABLE omop.CONDITION_OCCURRENCE ADD CONSTRAINT fpk_CONDITION_OCCURRENCE_condition_source_concept_id FOREIGN KEY (condition_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DRUG_EXPOSURE ADD CONSTRAINT fpk_DRUG_EXPOSURE_person_id FOREIGN KEY (person_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.DRUG_EXPOSURE ADD CONSTRAINT fpk_DRUG_EXPOSURE_drug_concept_id FOREIGN KEY (drug_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DRUG_EXPOSURE ADD CONSTRAINT fpk_DRUG_EXPOSURE_drug_type_concept_id FOREIGN KEY (drug_type_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DRUG_EXPOSURE ADD CONSTRAINT fpk_DRUG_EXPOSURE_route_concept_id FOREIGN KEY (route_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DRUG_EXPOSURE ADD CONSTRAINT fpk_DRUG_EXPOSURE_provider_id FOREIGN KEY (provider_id) REFERENCES omop.PROVIDER (PROVIDER_ID);

ALTER TABLE omop.DRUG_EXPOSURE ADD CONSTRAINT fpk_DRUG_EXPOSURE_visit_occurrence_id FOREIGN KEY (visit_occurrence_id) REFERENCES omop.VISIT_OCCURRENCE (VISIT_OCCURRENCE_ID);

ALTER TABLE omop.DRUG_EXPOSURE ADD CONSTRAINT fpk_DRUG_EXPOSURE_visit_detail_id FOREIGN KEY (visit_detail_id) REFERENCES omop.VISIT_DETAIL (VISIT_DETAIL_ID);

ALTER TABLE omop.DRUG_EXPOSURE ADD CONSTRAINT fpk_DRUG_EXPOSURE_drug_source_concept_id FOREIGN KEY (drug_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PROCEDURE_OCCURRENCE ADD CONSTRAINT fpk_PROCEDURE_OCCURRENCE_person_id FOREIGN KEY (person_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.PROCEDURE_OCCURRENCE ADD CONSTRAINT fpk_PROCEDURE_OCCURRENCE_procedure_concept_id FOREIGN KEY (procedure_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PROCEDURE_OCCURRENCE ADD CONSTRAINT fpk_PROCEDURE_OCCURRENCE_procedure_type_concept_id FOREIGN KEY (procedure_type_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PROCEDURE_OCCURRENCE ADD CONSTRAINT fpk_PROCEDURE_OCCURRENCE_modifier_concept_id FOREIGN KEY (modifier_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PROCEDURE_OCCURRENCE ADD CONSTRAINT fpk_PROCEDURE_OCCURRENCE_provider_id FOREIGN KEY (provider_id) REFERENCES omop.PROVIDER (PROVIDER_ID);

ALTER TABLE omop.PROCEDURE_OCCURRENCE ADD CONSTRAINT fpk_PROCEDURE_OCCURRENCE_visit_occurrence_id FOREIGN KEY (visit_occurrence_id) REFERENCES omop.VISIT_OCCURRENCE (VISIT_OCCURRENCE_ID);

ALTER TABLE omop.PROCEDURE_OCCURRENCE ADD CONSTRAINT fpk_PROCEDURE_OCCURRENCE_visit_detail_id FOREIGN KEY (visit_detail_id) REFERENCES omop.VISIT_DETAIL (VISIT_DETAIL_ID);

ALTER TABLE omop.PROCEDURE_OCCURRENCE ADD CONSTRAINT fpk_PROCEDURE_OCCURRENCE_procedure_source_concept_id FOREIGN KEY (procedure_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DEVICE_EXPOSURE ADD CONSTRAINT fpk_DEVICE_EXPOSURE_person_id FOREIGN KEY (person_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.DEVICE_EXPOSURE ADD CONSTRAINT fpk_DEVICE_EXPOSURE_device_concept_id FOREIGN KEY (device_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DEVICE_EXPOSURE ADD CONSTRAINT fpk_DEVICE_EXPOSURE_device_type_concept_id FOREIGN KEY (device_type_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DEVICE_EXPOSURE ADD CONSTRAINT fpk_DEVICE_EXPOSURE_provider_id FOREIGN KEY (provider_id) REFERENCES omop.PROVIDER (PROVIDER_ID);

ALTER TABLE omop.DEVICE_EXPOSURE ADD CONSTRAINT fpk_DEVICE_EXPOSURE_visit_occurrence_id FOREIGN KEY (visit_occurrence_id) REFERENCES omop.VISIT_OCCURRENCE (VISIT_OCCURRENCE_ID);

ALTER TABLE omop.DEVICE_EXPOSURE ADD CONSTRAINT fpk_DEVICE_EXPOSURE_visit_detail_id FOREIGN KEY (visit_detail_id) REFERENCES omop.VISIT_DETAIL (VISIT_DETAIL_ID);

ALTER TABLE omop.DEVICE_EXPOSURE ADD CONSTRAINT fpk_DEVICE_EXPOSURE_device_source_concept_id FOREIGN KEY (device_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DEVICE_EXPOSURE ADD CONSTRAINT fpk_DEVICE_EXPOSURE_unit_concept_id FOREIGN KEY (unit_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DEVICE_EXPOSURE ADD CONSTRAINT fpk_DEVICE_EXPOSURE_unit_source_concept_id FOREIGN KEY (unit_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.MEASUREMENT ADD CONSTRAINT fpk_MEASUREMENT_person_id FOREIGN KEY (person_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.MEASUREMENT ADD CONSTRAINT fpk_MEASUREMENT_measurement_concept_id FOREIGN KEY (measurement_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.MEASUREMENT ADD CONSTRAINT fpk_MEASUREMENT_measurement_type_concept_id FOREIGN KEY (measurement_type_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.MEASUREMENT ADD CONSTRAINT fpk_MEASUREMENT_operator_concept_id FOREIGN KEY (operator_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.MEASUREMENT ADD CONSTRAINT fpk_MEASUREMENT_value_as_concept_id FOREIGN KEY (value_as_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.MEASUREMENT ADD CONSTRAINT fpk_MEASUREMENT_unit_concept_id FOREIGN KEY (unit_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.MEASUREMENT ADD CONSTRAINT fpk_MEASUREMENT_provider_id FOREIGN KEY (provider_id) REFERENCES omop.PROVIDER (PROVIDER_ID);

ALTER TABLE omop.MEASUREMENT ADD CONSTRAINT fpk_MEASUREMENT_visit_occurrence_id FOREIGN KEY (visit_occurrence_id) REFERENCES omop.VISIT_OCCURRENCE (VISIT_OCCURRENCE_ID);

ALTER TABLE omop.MEASUREMENT ADD CONSTRAINT fpk_MEASUREMENT_visit_detail_id FOREIGN KEY (visit_detail_id) REFERENCES omop.VISIT_DETAIL (VISIT_DETAIL_ID);

ALTER TABLE omop.MEASUREMENT ADD CONSTRAINT fpk_MEASUREMENT_measurement_source_concept_id FOREIGN KEY (measurement_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.MEASUREMENT ADD CONSTRAINT fpk_MEASUREMENT_unit_source_concept_id FOREIGN KEY (unit_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.MEASUREMENT ADD CONSTRAINT fpk_MEASUREMENT_meas_event_field_concept_id FOREIGN KEY (meas_event_field_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.OBSERVATION ADD CONSTRAINT fpk_OBSERVATION_person_id FOREIGN KEY (person_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.OBSERVATION ADD CONSTRAINT fpk_OBSERVATION_observation_concept_id FOREIGN KEY (observation_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.OBSERVATION ADD CONSTRAINT fpk_OBSERVATION_observation_type_concept_id FOREIGN KEY (observation_type_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.OBSERVATION ADD CONSTRAINT fpk_OBSERVATION_value_as_concept_id FOREIGN KEY (value_as_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.OBSERVATION ADD CONSTRAINT fpk_OBSERVATION_qualifier_concept_id FOREIGN KEY (qualifier_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.OBSERVATION ADD CONSTRAINT fpk_OBSERVATION_unit_concept_id FOREIGN KEY (unit_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.OBSERVATION ADD CONSTRAINT fpk_OBSERVATION_provider_id FOREIGN KEY (provider_id) REFERENCES omop.PROVIDER (PROVIDER_ID);

ALTER TABLE omop.OBSERVATION ADD CONSTRAINT fpk_OBSERVATION_visit_occurrence_id FOREIGN KEY (visit_occurrence_id) REFERENCES omop.VISIT_OCCURRENCE (VISIT_OCCURRENCE_ID);

ALTER TABLE omop.OBSERVATION ADD CONSTRAINT fpk_OBSERVATION_visit_detail_id FOREIGN KEY (visit_detail_id) REFERENCES omop.VISIT_DETAIL (VISIT_DETAIL_ID);

ALTER TABLE omop.OBSERVATION ADD CONSTRAINT fpk_OBSERVATION_observation_source_concept_id FOREIGN KEY (observation_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.OBSERVATION ADD CONSTRAINT fpk_OBSERVATION_obs_event_field_concept_id FOREIGN KEY (obs_event_field_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DEATH ADD CONSTRAINT fpk_DEATH_person_id FOREIGN KEY (person_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.DEATH ADD CONSTRAINT fpk_DEATH_death_type_concept_id FOREIGN KEY (death_type_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DEATH ADD CONSTRAINT fpk_DEATH_cause_concept_id FOREIGN KEY (cause_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DEATH ADD CONSTRAINT fpk_DEATH_cause_source_concept_id FOREIGN KEY (cause_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.NOTE ADD CONSTRAINT fpk_NOTE_person_id FOREIGN KEY (person_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.NOTE ADD CONSTRAINT fpk_NOTE_note_type_concept_id FOREIGN KEY (note_type_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.NOTE ADD CONSTRAINT fpk_NOTE_note_class_concept_id FOREIGN KEY (note_class_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.NOTE ADD CONSTRAINT fpk_NOTE_encoding_concept_id FOREIGN KEY (encoding_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.NOTE ADD CONSTRAINT fpk_NOTE_language_concept_id FOREIGN KEY (language_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.NOTE ADD CONSTRAINT fpk_NOTE_provider_id FOREIGN KEY (provider_id) REFERENCES omop.PROVIDER (PROVIDER_ID);

ALTER TABLE omop.NOTE ADD CONSTRAINT fpk_NOTE_visit_occurrence_id FOREIGN KEY (visit_occurrence_id) REFERENCES omop.VISIT_OCCURRENCE (VISIT_OCCURRENCE_ID);

ALTER TABLE omop.NOTE ADD CONSTRAINT fpk_NOTE_visit_detail_id FOREIGN KEY (visit_detail_id) REFERENCES omop.VISIT_DETAIL (VISIT_DETAIL_ID);

ALTER TABLE omop.NOTE ADD CONSTRAINT fpk_NOTE_note_event_field_concept_id FOREIGN KEY (note_event_field_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.NOTE_NLP ADD CONSTRAINT fpk_NOTE_NLP_section_concept_id FOREIGN KEY (section_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.NOTE_NLP ADD CONSTRAINT fpk_NOTE_NLP_note_nlp_concept_id FOREIGN KEY (note_nlp_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.NOTE_NLP ADD CONSTRAINT fpk_NOTE_NLP_note_nlp_source_concept_id FOREIGN KEY (note_nlp_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.SPECIMEN ADD CONSTRAINT fpk_SPECIMEN_person_id FOREIGN KEY (person_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.SPECIMEN ADD CONSTRAINT fpk_SPECIMEN_specimen_concept_id FOREIGN KEY (specimen_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.SPECIMEN ADD CONSTRAINT fpk_SPECIMEN_specimen_type_concept_id FOREIGN KEY (specimen_type_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.SPECIMEN ADD CONSTRAINT fpk_SPECIMEN_unit_concept_id FOREIGN KEY (unit_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.SPECIMEN ADD CONSTRAINT fpk_SPECIMEN_anatomic_site_concept_id FOREIGN KEY (anatomic_site_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.SPECIMEN ADD CONSTRAINT fpk_SPECIMEN_disease_status_concept_id FOREIGN KEY (disease_status_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.FACT_RELATIONSHIP ADD CONSTRAINT fpk_FACT_RELATIONSHIP_domain_concept_id_1 FOREIGN KEY (domain_concept_id_1) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.FACT_RELATIONSHIP ADD CONSTRAINT fpk_FACT_RELATIONSHIP_domain_concept_id_2 FOREIGN KEY (domain_concept_id_2) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.FACT_RELATIONSHIP ADD CONSTRAINT fpk_FACT_RELATIONSHIP_relationship_concept_id FOREIGN KEY (relationship_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.LOCATION ADD CONSTRAINT fpk_LOCATION_country_concept_id FOREIGN KEY (country_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.CARE_SITE ADD CONSTRAINT fpk_CARE_SITE_place_of_service_concept_id FOREIGN KEY (place_of_service_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.CARE_SITE ADD CONSTRAINT fpk_CARE_SITE_location_id FOREIGN KEY (location_id) REFERENCES omop.LOCATION (LOCATION_ID);

ALTER TABLE omop.PROVIDER ADD CONSTRAINT fpk_PROVIDER_specialty_concept_id FOREIGN KEY (specialty_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PROVIDER ADD CONSTRAINT fpk_PROVIDER_care_site_id FOREIGN KEY (care_site_id) REFERENCES omop.CARE_SITE (CARE_SITE_ID);

ALTER TABLE omop.PROVIDER ADD CONSTRAINT fpk_PROVIDER_gender_concept_id FOREIGN KEY (gender_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PROVIDER ADD CONSTRAINT fpk_PROVIDER_specialty_source_concept_id FOREIGN KEY (specialty_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PROVIDER ADD CONSTRAINT fpk_PROVIDER_gender_source_concept_id FOREIGN KEY (gender_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PAYER_PLAN_PERIOD ADD CONSTRAINT fpk_PAYER_PLAN_PERIOD_payer_plan_period_id FOREIGN KEY (payer_plan_period_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.PAYER_PLAN_PERIOD ADD CONSTRAINT fpk_PAYER_PLAN_PERIOD_person_id FOREIGN KEY (person_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.PAYER_PLAN_PERIOD ADD CONSTRAINT fpk_PAYER_PLAN_PERIOD_payer_concept_id FOREIGN KEY (payer_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PAYER_PLAN_PERIOD ADD CONSTRAINT fpk_PAYER_PLAN_PERIOD_payer_source_concept_id FOREIGN KEY (payer_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PAYER_PLAN_PERIOD ADD CONSTRAINT fpk_PAYER_PLAN_PERIOD_plan_concept_id FOREIGN KEY (plan_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PAYER_PLAN_PERIOD ADD CONSTRAINT fpk_PAYER_PLAN_PERIOD_plan_source_concept_id FOREIGN KEY (plan_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PAYER_PLAN_PERIOD ADD CONSTRAINT fpk_PAYER_PLAN_PERIOD_sponsor_concept_id FOREIGN KEY (sponsor_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PAYER_PLAN_PERIOD ADD CONSTRAINT fpk_PAYER_PLAN_PERIOD_sponsor_source_concept_id FOREIGN KEY (sponsor_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PAYER_PLAN_PERIOD ADD CONSTRAINT fpk_PAYER_PLAN_PERIOD_stop_reason_concept_id FOREIGN KEY (stop_reason_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.PAYER_PLAN_PERIOD ADD CONSTRAINT fpk_PAYER_PLAN_PERIOD_stop_reason_source_concept_id FOREIGN KEY (stop_reason_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.COST ADD CONSTRAINT fpk_COST_cost_domain_id FOREIGN KEY (cost_domain_id) REFERENCES omop.DOMAIN (DOMAIN_ID);

ALTER TABLE omop.COST ADD CONSTRAINT fpk_COST_cost_type_concept_id FOREIGN KEY (cost_type_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.COST ADD CONSTRAINT fpk_COST_currency_concept_id FOREIGN KEY (currency_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.COST ADD CONSTRAINT fpk_COST_revenue_code_concept_id FOREIGN KEY (revenue_code_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.COST ADD CONSTRAINT fpk_COST_drg_concept_id FOREIGN KEY (drg_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DRUG_ERA ADD CONSTRAINT fpk_DRUG_ERA_person_id FOREIGN KEY (person_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.DRUG_ERA ADD CONSTRAINT fpk_DRUG_ERA_drug_concept_id FOREIGN KEY (drug_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DOSE_ERA ADD CONSTRAINT fpk_DOSE_ERA_person_id FOREIGN KEY (person_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.DOSE_ERA ADD CONSTRAINT fpk_DOSE_ERA_drug_concept_id FOREIGN KEY (drug_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DOSE_ERA ADD CONSTRAINT fpk_DOSE_ERA_unit_concept_id FOREIGN KEY (unit_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.CONDITION_ERA ADD CONSTRAINT fpk_CONDITION_ERA_person_id FOREIGN KEY (person_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.CONDITION_ERA ADD CONSTRAINT fpk_CONDITION_ERA_condition_concept_id FOREIGN KEY (condition_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.EPISODE ADD CONSTRAINT fpk_EPISODE_person_id FOREIGN KEY (person_id) REFERENCES omop.PERSON (PERSON_ID);

ALTER TABLE omop.EPISODE ADD CONSTRAINT fpk_EPISODE_episode_concept_id FOREIGN KEY (episode_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.EPISODE ADD CONSTRAINT fpk_EPISODE_episode_object_concept_id FOREIGN KEY (episode_object_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.EPISODE ADD CONSTRAINT fpk_EPISODE_episode_type_concept_id FOREIGN KEY (episode_type_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.EPISODE ADD CONSTRAINT fpk_EPISODE_episode_source_concept_id FOREIGN KEY (episode_source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.EPISODE_EVENT ADD CONSTRAINT fpk_EPISODE_EVENT_episode_id FOREIGN KEY (episode_id) REFERENCES omop.EPISODE (EPISODE_ID);

ALTER TABLE omop.EPISODE_EVENT ADD CONSTRAINT fpk_EPISODE_EVENT_episode_event_field_concept_id FOREIGN KEY (episode_event_field_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.METADATA ADD CONSTRAINT fpk_METADATA_metadata_concept_id FOREIGN KEY (metadata_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.METADATA ADD CONSTRAINT fpk_METADATA_metadata_type_concept_id FOREIGN KEY (metadata_type_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.METADATA ADD CONSTRAINT fpk_METADATA_value_as_concept_id FOREIGN KEY (value_as_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.CDM_SOURCE ADD CONSTRAINT fpk_CDM_SOURCE_cdm_version_concept_id FOREIGN KEY (cdm_version_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.CONCEPT ADD CONSTRAINT fpk_CONCEPT_domain_id FOREIGN KEY (domain_id) REFERENCES omop.DOMAIN (DOMAIN_ID);

ALTER TABLE omop.CONCEPT ADD CONSTRAINT fpk_CONCEPT_vocabulary_id FOREIGN KEY (vocabulary_id) REFERENCES omop.VOCABULARY (VOCABULARY_ID);

ALTER TABLE omop.CONCEPT ADD CONSTRAINT fpk_CONCEPT_concept_class_id FOREIGN KEY (concept_class_id) REFERENCES omop.CONCEPT_CLASS (CONCEPT_CLASS_ID);

ALTER TABLE omop.VOCABULARY ADD CONSTRAINT fpk_VOCABULARY_vocabulary_concept_id FOREIGN KEY (vocabulary_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DOMAIN ADD CONSTRAINT fpk_DOMAIN_domain_concept_id FOREIGN KEY (domain_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.CONCEPT_CLASS ADD CONSTRAINT fpk_CONCEPT_CLASS_concept_class_concept_id FOREIGN KEY (concept_class_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.CONCEPT_RELATIONSHIP ADD CONSTRAINT fpk_CONCEPT_RELATIONSHIP_concept_id_1 FOREIGN KEY (concept_id_1) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.CONCEPT_RELATIONSHIP ADD CONSTRAINT fpk_CONCEPT_RELATIONSHIP_concept_id_2 FOREIGN KEY (concept_id_2) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.CONCEPT_RELATIONSHIP ADD CONSTRAINT fpk_CONCEPT_RELATIONSHIP_relationship_id FOREIGN KEY (relationship_id) REFERENCES omop.RELATIONSHIP (RELATIONSHIP_ID);

ALTER TABLE omop.RELATIONSHIP ADD CONSTRAINT fpk_RELATIONSHIP_relationship_concept_id FOREIGN KEY (relationship_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.CONCEPT_SYNONYM ADD CONSTRAINT fpk_CONCEPT_SYNONYM_concept_id FOREIGN KEY (concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.CONCEPT_SYNONYM ADD CONSTRAINT fpk_CONCEPT_SYNONYM_language_concept_id FOREIGN KEY (language_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.CONCEPT_ANCESTOR ADD CONSTRAINT fpk_CONCEPT_ANCESTOR_ancestor_concept_id FOREIGN KEY (ancestor_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.CONCEPT_ANCESTOR ADD CONSTRAINT fpk_CONCEPT_ANCESTOR_descendant_concept_id FOREIGN KEY (descendant_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.SOURCE_TO_CONCEPT_MAP ADD CONSTRAINT fpk_SOURCE_TO_CONCEPT_MAP_source_concept_id FOREIGN KEY (source_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.SOURCE_TO_CONCEPT_MAP ADD CONSTRAINT fpk_SOURCE_TO_CONCEPT_MAP_target_concept_id FOREIGN KEY (target_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.SOURCE_TO_CONCEPT_MAP ADD CONSTRAINT fpk_SOURCE_TO_CONCEPT_MAP_target_vocabulary_id FOREIGN KEY (target_vocabulary_id) REFERENCES omop.VOCABULARY (VOCABULARY_ID);

ALTER TABLE omop.DRUG_STRENGTH ADD CONSTRAINT fpk_DRUG_STRENGTH_drug_concept_id FOREIGN KEY (drug_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DRUG_STRENGTH ADD CONSTRAINT fpk_DRUG_STRENGTH_ingredient_concept_id FOREIGN KEY (ingredient_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DRUG_STRENGTH ADD CONSTRAINT fpk_DRUG_STRENGTH_amount_unit_concept_id FOREIGN KEY (amount_unit_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DRUG_STRENGTH ADD CONSTRAINT fpk_DRUG_STRENGTH_numerator_unit_concept_id FOREIGN KEY (numerator_unit_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.DRUG_STRENGTH ADD CONSTRAINT fpk_DRUG_STRENGTH_denominator_unit_concept_id FOREIGN KEY (denominator_unit_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);
Pepe Marquez's avatar
scripts sql para instancia de omop en PostgreSQL y MySQL  
Pepe Marquez committed
353 
ALTER TABLE omop.COHORT ADD CONSTRAINT fpk_COHORT_cohort_definition_id FOREIGN KEY (cohort_definition_id) REFERENCES omop.COHORT_DEFINITION (COHORT_DEFINITION_ID);
Pepe Marquez's avatar
instancia de omop en postgres  
Pepe Marquez committed
354 355 356 357 358 

ALTER TABLE omop.COHORT_DEFINITION ADD CONSTRAINT fpk_COHORT_DEFINITION_definition_type_concept_id FOREIGN KEY (definition_type_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);

ALTER TABLE omop.COHORT_DEFINITION ADD CONSTRAINT fpk_COHORT_DEFINITION_subject_concept_id FOREIGN KEY (subject_concept_id) REFERENCES omop.CONCEPT (CONCEPT_ID);