Auth Connect Sso Sessions Table Schema (auth_connect_sso_sessions)


Description

List of SSO sessions on Client system, columns are not normalised to allow strict validation

auth_connect_sso_sessions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
sid VARCHAR 128

The session id of PHP session on the client
ssotoken VARCHAR 64

Token used for identification of SSO session, this needs to be used together with client or server secret because it may end up in web server logs
serverid BIGINT 19 null
auth_connect_servers.id authconnssosess_ser2_fk R
serveruserid BIGINT 19 null
userid BIGINT 19 null
user.id authconnssosess_use2_fk R
timecreated BIGINT 19 null

Table contained -1 rows

auth_connect_sso_sessions table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
authconnssosess_ser_ix Performance Asc serverid
authconnssosess_sid_uix Must be unique Asc sid
authconnssosess_use_ix Performance Asc userid

auth_connect_sso_sessions table relationships

Close relationships within degrees of separation