ERD

erDiagram
  organisation_location {
    organisation_id BIGINT PK, FK
    location_id BIGINT PK, FK
    organisation VARCHAR PK, FK
    organisation_guid VARCHAR
    location_guid VARCHAR
    is_main_location BOOLEAN
  }

  organisation_location }|--|| organisation : organisation_id
  organisation {
    organisation_id BIGINT PK
    organisation VARCHAR PK
    organisation_guid VARCHAR
  }

  organisation_location }|--|| location : location_id
  location {
    location_id BIGINT PK
    organisation VARCHAR PK, FK
    location_guid VARCHAR
  }