oauth2_server_clients

0 rows


Description

OAuth2 server clients

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
name VARCHAR 255 ''

Human-readable name of the OAuth2 client

description LONGTEXT 2147483647 √ NULL

Optional human-readable description of the OAuth2 client

clientidentifier VARCHAR 255 ''
oauth2_server_client_access_tokens.clientidentifier oautservclieaccetoke_cli2_fkR
oauth2_server_client_auth_codes.clientidentifier oautservclieauthcode_cli2_fkR
oauth2_server_client_granted_scopes.clientidentifier oautservcliegranscop_cli2_fkR
oauth2_server_client_redirect_uris.clientidentifier oautservclierediuris_cli2_fkR
oauth2_server_client_secrets.clientidentifier oautservcliesecr_cli2_fkR

Public OAuth2 Client identifier used in token requests

ownercontext BIGINT 19 null

Context ID representing the owner of the OAuth client

status BIT 3 null

Current lifecycle status of the OAuth2 client

isconfidential BIT 3 1

Indicates if the OAuth2 client can securely maintain a secret

granttypes VARCHAR 255 √ NULL

The OAuth2 grant types supported by the client, represented as comma-separated values

ispkcerequired BIT 3 1

Indicates whether PKCE is required for the OAuth2 client

timecreated BIGINT 19 null

Creation timestamp

timemodified BIGINT 19 √ NULL

Last modification timestamp

lastaccessed BIGINT 19 √ NULL

Last accessed timestamp

scopes LONGTEXT 2147483647 null

The list of scopes that this client is permitted to issue

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
oautservclie_cli_uix Must be unique Asc clientidentifier

Relationships