You can use fact_relationship table
https://github.com/OHDSI/CommonDataModel/wiki/FACT_RELATIONSHIP
where
domain_concept_id_1 = ‘Note’
fact_id_1 = Note.visit_occurrence_id
domain_concept_id_2 = ‘Measurement’ (if measurement)
fact_id_2 = Measurement.Measurement_concept_id
relationship_concept_id = ??? “Note of”
We don’t have this relationship currently.
@Christian_Reich, we need to think about new relationships adding process