Auth Connect Servers Table Schema (auth_connect_servers)


Description

List of servers

auth_connect_servers table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
auth_connect_ids.serverid authconnids_ser2_fk R
auth_connect_sso_requests.serverid authconnssorequ_ser2_fk R
auth_connect_sso_sessions.serverid authconnssosess_ser2_fk R
auth_connect_user_collections.serverid authconnusercoll_ser2_fk R
auth_connect_users.serverid authconnuser_ser2_fk R
status BIT 1 null

0 means ok, anything else means do not use
serveridnumber VARCHAR 64

World unique server ID
serversecret VARCHAR 64

Secret this client uses in server requests
serverurl VARCHAR 255

URL of Totara Connect server - wwwroot
servername VARCHAR 255

Name received from server, for UI identification only
servercomment LONGTEXT 2147483647 null

Comments by client administrator
clientidnumber VARCHAR 64

World unique client ID, server is using it in client requests
clientsecret VARCHAR 64

Secret the server is using in client requests
apiversion BIGINT 19 null

The API version used for communication
timecreated BIGINT 19 null
timemodified BIGINT 19 null

Table contained -1 rows

auth_connect_servers table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
authconnserv_cli_uix Must be unique Asc clientidnumber
authconnserv_ser_uix Must be unique Asc serveridnumber

auth_connect_servers table relationships

Close relationships within degrees of separation