We have the cases where relationship_id we needed don't exist
Cancer diagnosis to cancer stage
Smoking status to disorder observed
Antibiotic [Susceptibility] to Organism detection
1) should we create all possible domain combination relationships
Condition to Observation
Condition to Measurement, Condition to Drug, etc.?
as 581410 Observation to Measurement is created.
Actually it doesn't make a lot of sense as we have domain_concept_id_1 and domain_concept_id_2 in fact_relationship already
2) should we create the relationship for each use case?
"Cancer diagnosis to cancer stage"
"Susceptibility to Organism"
3) allow populate the concept_relationship with "0"
I like the 2nd option as it actually represents the logic behind the connection. But in this case we need to develop the way these new relationships will be added to the OHDSI vocabulary.