oauth2_server_client_granted_scopes

0 rows


Description

User consent and granted scopes for OAuth2 clients

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
clientidentifier VARCHAR 255 ''
oauth2_server_clients.clientidentifier oautservcliegranscop_cli2_fkR

OAuth2 client identifier

userid BIGINT 19 null
user.id oautservcliegranscop_use2_fkR

User ID of the resource owner who approved the application access

scope LONGTEXT 2147483647 null

Scope explicitly granted to this client by the user

timecreated BIGINT 19 null

Creation timestamp

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
oautservcliegranscop_cli_ix Performance Asc clientidentifier
oautservcliegranscop_clius_uix Must be unique Asc/Asc clientidentifier + userid
oautservcliegranscop_use_ix Performance Asc userid

Relationships