ERD

erDiagram
  bulk_admin_organisation {
    UNIQUEIDENTIFIER organisationguid PK
    UNIQUEIDENTIFIER parentorganisationguid FK
    UNIQUEIDENTIFIER ccgorganisationguid FK
    UNIQUEIDENTIFIER mainlocationguid FK
  }

  bulk_admin_location {
    UNIQUEIDENTIFIER locationguid PK
  }

  bulk_admin_organisation }o--|| bulk_admin_location : mainlocationguid