ERD

erDiagram
  user_in_role {
    user_in_role_id BIGINT PK
    organisation VARCHAR PK, FK
    user_in_role_guid VARCHAR
    organisation_id BIGINT FK
    organisation_guid VARCHAR
    user_id BIGINT
  }

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

  user_in_role ||--o{ appointment_session_user : user_in_role_id
  appointment_session_user {
    session_id BIGINT PK
    user_in_role_id BIGINT PK, FK
    organisation VARCHAR PK, FK
  }