ERD

erDiagram
  referral {
    referral_observation_id VARBINARY PK
    organisation VARCHAR PK
  }
  referral }|--|{ patient : patient_id
  patient {
    patient_id VARBINARY PK
    organisation VARCHAR FK
  }
  referral }|--|| observation : referral_observation_id
  observation {
    observation_id VARBINARY PK
    organisation VARCHAR FK
  }
  referral }|--o| consultation : consultation_id
  consultation {
    consultation_id VARBINARY PK
    organisation VARCHAR FK
  }
  referral }|--o| codeable_concept : code_id
  codeable_concept {
    code_id BIGINT PK
    organisation VARCHAR FK
  }