Totara Connect Sso Sessions Table Schema (totara_connect_sso_sessions)


Description

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
totara_connect_clients.id totaconnssosess_cli2_fk R
userid BIGINT 19 null
user.id 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

Close relationships within degrees of separation