ERD

erDiagram
  bulk_carerecord_observationreferral {
    UNIQUEIDENTIFIER observationguid PK
    UNIQUEIDENTIFIER patientguid FK
    UNIQUEIDENTIFIER organisationguid FK
    UNIQUEIDENTIFIER referraltargetorganisationguid FK
    BIGINT referralsourceid FK
    BIGINT referralreasoncodeid FK
    BIGINT referralepisoderttmeasurementtypeid FK
    BIGINT referralclosurereasoncodeid FK
  }

  bulk_carerecord_observation {
    UNIQUEIDENTIFIER observationguid PK
  }

  bulk_admin_patient {
    UNIQUEIDENTIFIER patientguid PK
  }

  bulk_admin_organisation {
    UNIQUEIDENTIFIER organisationguid PK
  }

  bulk_clinicalcode {
    BIGINT codeid PK
  }

  bulk_carerecord_observationreferral }o--|| bulk_carerecord_observation : observationguid
  bulk_carerecord_observationreferral }o--|| bulk_admin_patient : patientguid
  bulk_carerecord_observationreferral }o--|| bulk_admin_organisation : organisationguid
  bulk_carerecord_observationreferral }o--|| bulk_admin_organisation : referraltargetorganisationguid
  bulk_carerecord_observationreferral }o--o| bulk_clinicalcode : referralsourceid
  bulk_carerecord_observationreferral }o--o| bulk_clinicalcode : referralreasoncodeid
  bulk_carerecord_observationreferral }o--o| bulk_clinicalcode : referralepisoderttmeasurementtypeid
  bulk_carerecord_observationreferral }o--o| bulk_clinicalcode : referralclosurereasoncodeid