0 rows


A table to store the client’s id and secret that we are providing to other parties


Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_totara_oauth2_client_provider_id_seq'::regclass)
app_totara_oauth2_access_token.client_provider_id Defined in XMLR
client_id varchar 80 ''::character varying
client_secret varchar 80 ''::character varying
name varchar 255 ''::character varying
description text 2147483647 null
description_format int2 5 null
scope varchar 1333 null
grant_types varchar 80 null
internal int2 5 0
time_created int8 19 null
status int2 5 1
tenant_id int8 19 null Defined in XMLR
component varchar 100 null


Constraint Name Type Sort Column(s)
app_totaoautclieprov_id_pk Primary key Asc id
app_totaoautclieprov_cli2_uix Must be unique Asc client_secret
app_totaoautclieprov_cli_uix Must be unique Asc client_id
app_totaoautclieprov_nam_ix Performance Asc name
app_totaoautclieprov_ten_ix Performance Asc tenant_id
app_totaoautclieprov_tim_ix Performance Asc time_created