ERD

erDiagram
  bulk_carerecord_consultation {
    UNIQUEIDENTIFIER consultationguid PK
    UNIQUEIDENTIFIER patientguid FK
    UNIQUEIDENTIFIER organisationguid FK
    UNIQUEIDENTIFIER clinicianuserinroleguid FK
    UNIQUEIDENTIFIER enteredbyuserinroleguid FK
    UNIQUEIDENTIFIER appointmentslotguid FK
    BIGINT consultationsourcecodeid FK
  }

  bulk_admin_patient {
    UNIQUEIDENTIFIER patientguid PK
  }

  bulk_admin_organisation {
    UNIQUEIDENTIFIER organisationguid PK
  }

  bulk_admin_userinrole {
    UNIQUEIDENTIFIER userinroleguid PK
  }

  bulk_appointment_slot {
    UNIQUEIDENTIFIER slotguid PK
  }

  bulk_clinicalcode {
    BIGINT codeid PK
  }

  bulk_carerecord_consultation }o--|| bulk_admin_patient : patientguid
  bulk_carerecord_consultation }o--|| bulk_admin_organisation : organisationguid
  bulk_carerecord_consultation }o--o| bulk_admin_userinrole : clinicianuserinroleguid
  bulk_carerecord_consultation }o--o| bulk_admin_userinrole : enteredbyuserinroleguid
  bulk_carerecord_consultation }o--o| bulk_appointment_slot : appointmentslotguid
  bulk_carerecord_consultation }o--o| bulk_clinicalcode : consultationsourcecodeid