OHDSI Home | Forums | Wiki | Github

One Vocubulary schema for multiple CDM


(Chidam) #1

Hi All,
I want to setup multiple CDM, But i want to keep one vocubulary schema applicable for all CDM.
Example

  1. CDM
    only vocabulary schema
  2. CDM1
    dbo
    results
    temp
  3. CDM2
    dbo
    results
    temp

How to do the setting for this?
First CDM have only vocabulary. CDM1 and CDM2 have all the other tables, but don’t have vocobulary, this CDM1 and CDM2 need to refer CDM vocobulary

please advice
Chidam


(Chris Knoll) #2

Create views in each CDM that refer back to CDM’s vocabulary schema.


(Chidam) #3

Thanks Chris_Knoll,

Yes, i will create views.

chidam


(Chidam) #4

Hi Chris_Knoll,

I am using sql server. From the view not able to create foreign key referring concept table,
example for the person table, i need to create gender_concept_id column foreign key constraints to concept table.
any advise

thanks
regards
Chidam


(Chris Knoll) #5

Define the foreign key constraints back to the underlying tables, not your views. If this introduces other challenges, then you’ll have to just create copies of your vocabulary tables, one for each CDM.


t