ERD

erDiagram
  bulk_carerecord_observation {
    UNIQUEIDENTIFIER observationguid PK
    UNIQUEIDENTIFIER patientguid FK
    UNIQUEIDENTIFIER organisationguid FK
    UNIQUEIDENTIFIER clinicianuserinroleguid FK
    UNIQUEIDENTIFIER enteredbyuserinroleguid FK
    UNIQUEIDENTIFIER parentobservationguid FK
    BIGINT codeid FK
    UNIQUEIDENTIFIER problemguid FK
    UNIQUEIDENTIFIER consultationguid FK
  }

  bulk_admin_patient {
    UNIQUEIDENTIFIER patientguid PK
  }

  bulk_admin_organisation {
    UNIQUEIDENTIFIER organisationguid PK
  }

  bulk_admin_userinrole {
    UNIQUEIDENTIFIER userinroleguid PK
  }

  bulk_clinicalcode {
    BIGINT codeid PK
  }

  bulk_carerecord_problem {
    UNIQUEIDENTIFIER observationguid PK
  }

  bulk_carerecord_consultation {
    UNIQUEIDENTIFIER consultationguid PK
  }

  bulk_carerecord_observationreferral {
    UNIQUEIDENTIFIER observationguid PK
  }

  bulk_carerecord_observation }o--|| bulk_admin_patient : patientguid
  bulk_carerecord_observation }o--|| bulk_admin_organisation : organisationguid
  bulk_carerecord_observation }o--|| bulk_admin_userinrole : clinicianuserinroleguid
  bulk_carerecord_observation }o--|| bulk_admin_userinrole : enteredbyuserinroleguid
  bulk_carerecord_observation }o--|| bulk_clinicalcode : codeid
  bulk_carerecord_observation }o--o| bulk_carerecord_problem : problemguid
  bulk_carerecord_observation }o--o| bulk_carerecord_consultation : consultationguid
  bulk_carerecord_observation ||--o| bulk_carerecord_observationreferral : observationguid