ERD

erDiagram
  session_user {
    emis_session_guid VARCHAR PK
    emis_session_userinrole_guid VARCHAR FK
  }

  session {
    emis_session_guid VARCHAR PK
  }

  user_in_role {
    emis_userinrole_guid VARCHAR PK
  }

  session_user }|--|{ session : "for_session"
  session_user }|--|{ user_in_role : "for_user_in_role"