ERD

erDiagram
  family_history {
    observation_id INT PK
    member_key VARCHAR PK
    organisation VARCHAR PK
    patient_id INT FK
    patient_organisation_id INT FK
    observation_organisation_id INT FK
    code_id INT FK
    family_member_code_id INT FK
  }
  family_history }|--|{ observation : observation_id
  observation {
    observation_id INT PK
    organisation VARCHAR FK
  }
  family_history }|--|{ patient : patient_id
  patient {
    patient_id INT PK
    organisation VARCHAR FK
  }
  family_history }|--|{ organisation : patient_organisation_id
  family_history }|--|{ organisation : observation_organisation_id
  organisation {
    organisation_id INT PK
    organisation VARCHAR FK
  }
  family_history }|--|{ codeable_concept : code_id
  family_history }|--|{ codeable_concept : family_member_code_id
  codeable_concept {
    code_id INT PK
    organisation VARCHAR FK
  }