Is there a way to represent primary vs. secondary diagnosis in Conditions table?
You can use condition_type_concept_id for this purpose. Description here For example, secondary condition will have condition_type_concept_id 44786629 (here)