oauth2_server_client_access_tokens

0 rows


Description

OAuth2 access tokens issued to clients

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
identifier VARCHAR 255 ''
oauth2_server_client_refresh_tokens.accesstokenidentifier oautservclierefrtoke_acc2_fkR

Public OAuth2 access token identifier

userid BIGINT 19 √ NULL
user.id oautservclieaccetoke_use2_fkR

User ID of the access token owner

clientidentifier VARCHAR 255 ''
oauth2_server_clients.clientidentifier oautservclieaccetoke_cli2_fkR

OAuth2 client identifier

scopes LONGTEXT 2147483647 null

Space-separated list of scopes

expirytime BIGINT 19 null

Expiry timestamp

revoked BIT 3 0

Whether the OAuth2 access token is revoked

timecreated BIGINT 19 null

Creation timestamp

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
oautservclieaccetoke_cli_ix Performance Asc clientidentifier
oautservclieaccetoke_ide_uix Must be unique Asc identifier
oautservclieaccetoke_use_ix Performance Asc userid

Relationships