Totara Connect Sso Sessions Table Schema (totara_connect_sso_sessions)


List of all SSO sessions on client systems connect to this server

totara_connect_sso_sessions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
clientid BIGINT 19 null totaconnssosess_cli2_fk R
userid BIGINT 19 null totaconnssosess_use2_fk R
sid VARCHAR 128

Session id of the user session on the TC server

ssotoken VARCHAR 64

Token identifying SSO session on TC client

active BIT 1 0

Set to 1 after client fetches user data via get_sso_user

timecreated BIGINT 19 null

Table contained -1 rows

totara_connect_sso_sessions table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
totaconnssosess_cli_ix Performance Asc clientid
totaconnssosess_sso_uix Must be unique Asc ssotoken
totaconnssosess_use_ix Performance Asc userid

totara_connect_sso_sessions table relationships