ERD

erDiagram
  sharing_organisation {
    agreement_guid VARCHAR PK
    emis_organisation_guid VARCHAR FK
  }

  organisation {
    emis_organisation_guid VARCHAR PK
  }

  sharing_organisation }|--|{ organisation : "with_organisation"