ERD

erDiagram
  organisation {
    emis_organisation_guid VARCHAR PK
    emis_parent_organisation_guid VARCHAR FK
    emis_ccg_organisation_guid VARCHAR FK
    emis_main_location_guid VARCHAR FK
  }

  location {
    emis_location_guid VARCHAR PK
  }

  organisation }|--|{ organisation : "parent_organisation"
  organisation }|--|{ organisation : "ccg_organisation"
  organisation }|--|{ location : "main_location"