ERD

erDiagram
  location {
    emis_location_guid VARCHAR PK
    emis_parent_location_guid VARCHAR FK
  }

  location || -- o{ location : "parent_location"

  organisation {
    emis_organisation_guid VARCHAR PK
  }

  organisation || -- o{ location : "has_main_location"