ERD

erDiagram
  organisation {
    organisation_id INT PK
    organisation_guid VARCHAR
    organisation VARCHAR PK
    organisation_specialities ARRAY
  }
  organisation }|--|{ user_in_role : organisation_id
  user_in_role {
    organisation VARCHAR FK
    organisation_id INT FK
    organisation_guid VARCHAR FK
  }