Auth Connect Sso Sessions Table Schema (auth_connect_sso_sessions)


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 authconnssosess_ser2_fk R
serveruserid BIGINT 19 null
userid BIGINT 19 null 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