ERD

erDiagram
  user_in_role {
    user_in_role_id INT PK
    organisation VARCHAR PK
    user_in_role_guid VARCHAR
    organisation_id INT FK
    organisation_guid VARCHAR
    user_id INT
  }
  user_in_role }|--|{ organisation : organisation_id
  organisation {
    organisation VARCHAR FK
    organisation_id INT FK
    organisation_guid VARCHAR FK
  }
  user_in_role }|--|{ appointment_session_user : user_in_role_id
  appointment_session_user {
    user_in_role_id INT FK
    organisation VARCHAR FK
  }