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 0 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