ERD

erDiagram
  user_in_role {
    emis_userinrole_guid VARCHAR PK
    emis_employer_organisation_guid VARCHAR FK
  }

  organisation {
    emis_organisation_guid VARCHAR PK
  }

  user_in_role }|--|{ organisation : "employed_by"