ERD

erDiagram
  issue_record {
    issue_record_id VARBINARY PK
    organisation VARCHAR PK
  }
  issue_record }|--|{ patient : patient_id
  patient {
    patient_id BIGINT PK
    organisation VARCHAR FK
  }
  issue_record }|--o| consultation : consultation_id
  consultation {
    consultation_id VARBINARY PK
    organisation VARCHAR FK
  }
  issue_record }|--o| drug_record : drug_record_id
  drug_record {
    drug_record_id VARBINARY PK
    organisation VARCHAR FK
  }
  issue_record }|--o| codeable_concept : code_id
  codeable_concept {
    code_id BIGINT PK
    organisation VARCHAR FK
  }