app_totara_oauth2_client_provider

0 rows


Description

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

Columns

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
app_tenant.id Defined in XMLR
component varchar 100 √ null

Indexes

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

Relationships

Close relationships within degrees of separation