ERD

erDiagram
  bulk_prescribing_drugrecord {
    UNIQUEIDENTIFIER drugrecordguid PK
    UNIQUEIDENTIFIER patientguid FK
    UNIQUEIDENTIFIER organisationguid FK
    UNIQUEIDENTIFIER clinicianuserinroleguid FK
    UNIQUEIDENTIFIER enteredbyuserinroleguid FK
    BIGINT codeid FK
    UNIQUEIDENTIFIER problemobservationguid FK
  }

  bulk_admin_patient {
    UNIQUEIDENTIFIER patientguid PK
  }

  bulk_admin_organisation {
    UNIQUEIDENTIFIER organisationguid PK
  }

  bulk_admin_userinrole {
    UNIQUEIDENTIFIER userinroleguid PK
  }

  bulk_drugcode {
    BIGINT codeid PK
  }

  bulk_carerecord_problem {
    UNIQUEIDENTIFIER observationguid PK
  }

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