ad_authorizationcredential

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_authorizationcredential_id numeric 10 null
ad_authorizationaccount.ad_authorizationcredential_id adauthorizationcredential_adau R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
help varchar 2000 √ NULL::character varying
isactive bpchar 1 'Y'::bpchar
ad_authorizationcredential_uu varchar 36 √ NULL::character varying
name varchar 60 null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
authorizationclientid varchar 2000 NULL::character varying
authorizationclientsecret varchar 2000 NULL::character varying
authorizationredirecturl varchar 2000 NULL::character varying
ad_authorizationprovider_id numeric 10 null
ad_authorizationprovider.ad_authorizationprovider_id adauthorizationprovider_adauth R
ad_authorizationscopelist varchar 2000 NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_authorizationcredential_key Primary key Asc ad_authorizationcredential_id
ad_authorizationcredential_unq Must be unique Asc/Asc ad_client_id + name
ad_authorizationcredentiauuidx Must be unique Asc ad_authorizationcredential_uu

Check Constraints

Constraint Name Constraint
ad_authorizationcredential_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation