ERD

erDiagram
  bulk_prescribing_issuerecord {
    UNIQUEIDENTIFIER issuerecordguid PK
    UNIQUEIDENTIFIER patientguid FK
    UNIQUEIDENTIFIER organisationguid FK
    UNIQUEIDENTIFIER drugrecordguid FK
    UNIQUEIDENTIFIER clinicianuserinroleguid FK
    UNIQUEIDENTIFIER enteredbyuserinroleguid FK
    BIGINT codeid FK
    UNIQUEIDENTIFIER problemobservationguid FK
    UNIQUEIDENTIFIER consultationguid FK
  }

  bulk_admin_patient {
    UNIQUEIDENTIFIER patientguid PK
  }

  bulk_admin_organisation {
    UNIQUEIDENTIFIER organisationguid PK
  }

  bulk_prescribing_drugrecord {
    UNIQUEIDENTIFIER drugrecordguid PK
  }

  bulk_admin_userinrole {
    UNIQUEIDENTIFIER userinroleguid PK
  }

  bulk_drugcode {
    BIGINT codeid PK
  }

  bulk_carerecord_problem {
    UNIQUEIDENTIFIER observationguid PK
  }

  bulk_carerecord_consultation {
    UNIQUEIDENTIFIER consultationguid PK
  }

  bulk_prescribing_issuerecord }o--|| bulk_admin_patient : patientguid
  bulk_prescribing_issuerecord }o--|| bulk_admin_organisation : organisationguid
  bulk_prescribing_issuerecord }o--|| bulk_prescribing_drugrecord : drugrecordguid
  bulk_prescribing_issuerecord }o--|| bulk_admin_userinrole : clinicianuserinroleguid
  bulk_prescribing_issuerecord }o--|| bulk_admin_userinrole : enteredbyuserinroleguid
  bulk_prescribing_issuerecord }o--|| bulk_drugcode : codeid
  bulk_prescribing_issuerecord }o--o| bulk_carerecord_problem : problemobservationguid
  bulk_prescribing_issuerecord }o--o| bulk_carerecord_consultation : consultationguid