1.Where should I store Psychiatric sign or symptom,observation table or condition table?
2.There is no problem when they are stored into condition table,because most id domain of the sign or symptom are condition.But if we should store them into observation table,how do I choose the domain?
3.How should I store every single sign or symptom?Which field should I give?Whether should I link some other information using the event_field_id?
1, 2. Condition. See here: https://github.com/OHDSI/CommonDataModel/wiki/CONDITION_OCCURRENCE
“EHRs may capture Person conditions in the form of diagnosis codes or symptoms”
Please let me know if you can’t map some symptoms or signs to Condition concept.
3.
So, you store mapped concepts in CONDITION_OCCURRENCE.condition_concept_id.
To represent the source concpets you have to create custom concepts and put their concept_ids in CONDITION_OCCURRENCE.condition_source_concept_id
see https://github.com/OHDSI/CommonDataModel/wiki/Frequently-Asked-Questions, #15
What information you think can be connected? (for example diagnosis to symptoms?)
Got it!Thanks a lot.