ERD

erDiagram
  bulk_carerecord_diary {
    UNIQUEIDENTIFIER diaryguid PK
    UNIQUEIDENTIFIER patientguid FK
    UNIQUEIDENTIFIER organisationguid FK
    UNIQUEIDENTIFIER clinicianuserinroleguid FK
    UNIQUEIDENTIFIER enteredbyuserinroleguid FK
    BIGINT codeid 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_consultation {
    UNIQUEIDENTIFIER consultationguid PK
  }

  bulk_carerecord_diary }o--|| bulk_admin_patient : patientguid
  bulk_carerecord_diary }o--|| bulk_admin_organisation : organisationguid
  bulk_carerecord_diary }o--o| bulk_admin_userinrole : clinicianuserinroleguid
  bulk_carerecord_diary }o--o| bulk_admin_userinrole : enteredbyuserinroleguid
  bulk_carerecord_diary }o--|| bulk_clinicalcode : codeid
  bulk_carerecord_diary }o--o| bulk_carerecord_consultation : consultationguid