app_totara_connect_clients

0 rows


Description

List of client systems registered with this server

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_totara_connect_clients_id_seq'::regclass)
app_totara_connect_client_cohorts.clientid Defined in XML R
app_totara_connect_client_courses.clientid Defined in XML R
app_totara_connect_client_org_frameworks.clientid Defined in XML R
app_totara_connect_client_pos_frameworks.clientid Defined in XML R
app_totara_connect_sso_sessions.clientid Defined in XML R
status int2 5 null
clientidnumber varchar 64 ''::character varying
clientsecret varchar 64 ''::character varying
clienttype varchar 30 ''::character varying
clienturl varchar 255 ''::character varying
clientname varchar 255 ''::character varying
clientcomment text 2147483647 null
serversecret varchar 64 ''::character varying
cohortid int8 19 √ null
app_cohort.id Defined in XML R
syncprofilefields int2 5 0
addnewcohorts int2 5 0
addnewcourses int2 5 0
syncjobs int2 5 0
allowpluginsepservices int2 5 0
apiversion int8 19 null
timecreated int8 19 null
timemodified int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_totaconnclie_id_pk Primary key Asc id
app_totaconnclie_cli_uix Must be unique Asc clientidnumber
app_totaconnclie_coh_ix Performance Asc cohortid

Relationships

Close relationships within degrees of separation