app_auth_connect_sso_sessions

0 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_auth_connect_sso_sessions_id_seq'::regclass)
sid varchar 128 ''::character varying
ssotoken varchar 64 ''::character varying
serverid int8 19 null
app_auth_connect_servers.id Defined in XMLR
serveruserid int8 19 null
userid int8 19 null
app_user.id Defined in XMLR
timecreated int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_authconnssosess_id_pk Primary key Asc id
app_authconnssosess_ser_ix Performance Asc serverid
app_authconnssosess_sid_uix Must be unique Asc sid
app_authconnssosess_use_ix Performance Asc userid

Relationships

Close relationships within degrees of separation