oauth2_server_client_auth_codes

0 rows


Description

OAuth2 authorisation codes

Columns

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

Public OAuth2 authentication code identifier

userid BIGINT 19 null
user.id oautservclieauthcode_use2_fkR

User ID of the authorisation request approver

clientidentifier VARCHAR 255 ''
oauth2_server_clients.clientidentifier oautservclieauthcode_cli2_fkR

OAuth2 client identifier

redirecturi LONGTEXT 2147483647 null

Redirect URI used in authorisation request

scopes LONGTEXT 2147483647 null

Space-separated list of scopes

expirytime BIGINT 19 null

Expiry timestamp

revoked BIT 3 0

Whether the OAuth2 authorisation code is revoked

timecreated BIGINT 19 null

Creation timestamp

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
oautservclieauthcode_cli_ix Performance Asc clientidentifier
oautservclieauthcode_ide_uix Must be unique Asc identifier
oautservclieauthcode_use_ix Performance Asc userid

Relationships