ERD

erDiagram
  bulk_audit_patient_audit {
    UNIQUEIDENTIFIER itemguid PK
    UNIQUEIDENTIFIER patientguid FK
    UNIQUEIDENTIFIER organisationguid FK
    UNIQUEIDENTIFIER userinroleguid FK
  }

  bulk_admin_patient {
    UNIQUEIDENTIFIER patientguid PK
  }

  bulk_admin_organisation {
    UNIQUEIDENTIFIER organisationguid PK
  }

  bulk_admin_userinrole {
    UNIQUEIDENTIFIER userinroleguid PK
  }

  bulk_carerecord_consultation {
    UNIQUEIDENTIFIER consultationguid PK
  }

  bulk_carerecord_observation {
    UNIQUEIDENTIFIER observationguid PK
  }

  bulk_carerecord_diary {
    UNIQUEIDENTIFIER diaryguid PK
  }

  bulk_prescribing_drugrecord {
    UNIQUEIDENTIFIER drugrecordguid PK
  }

  bulk_prescribing_issuerecord {
    UNIQUEIDENTIFIER issuerecordguid PK
  }

  bulk_appointment_slot {
    UNIQUEIDENTIFIER slotguid PK
  }

  bulk_appointment_session {
    UNIQUEIDENTIFIER slotguid PK
  }

  bulk_audit_patient_audit }o--|| bulk_admin_patient : patientguid
  bulk_audit_patient_audit }o--|| bulk_admin_organisation : organisationguid
  bulk_audit_patient_audit }o--o| bulk_admin_userinrole : userinroleguid
  bulk_audit_patient_audit }o--o| bulk_carerecord_consultation : itemguid
  bulk_audit_patient_audit }o--o| bulk_carerecord_observation : itemguid
  bulk_audit_patient_audit }o--o| bulk_carerecord_diary : itemguid
  bulk_audit_patient_audit }o--o| bulk_prescribing_drugrecord : itemguid
  bulk_audit_patient_audit }o--o| bulk_prescribing_issuerecord : itemguid
  bulk_audit_patient_audit }o--o| bulk_appointment_slot : itemguid
  bulk_audit_patient_audit }o--|| bulk_appointment_session : sessionguid