ERD

erDiagram
  bulk_admin_organisationlocation {
    UNIQUEIDENTIFIER organisationguid PK
    UNIQUEIDENTIFIER locationguid PK
  }

  bulk_admin_organisation {
    UNIQUEIDENTIFIER organisationguid PK
  }

  bulk_admin_location {
    UNIQUEIDENTIFIER locationguid PK
  }

  bulk_admin_organisationlocation }o--|| bulk_admin_organisation : organisationguid
  bulk_admin_organisationlocation }o--|| bulk_admin_location : locationguid