oauth2_server_client_secrets

0 rows


Description

Secrets for OAuth2 clients

Columns

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

OAuth2 client identifier

secret VARCHAR 64 ''

OAuth2 Client secret

expirytime BIGINT 19 null

Expiry timestamp

revoked BIT 3 0

Whether the OAuth2 Client secret is revoked

timecreated BIGINT 19 null

Creation timestamp

lastaccessed BIGINT 19 √ NULL

Timestamp when the client secret was last successfully used to authenticate a client

lastexpirynotification BIGINT 19 √ NULL

Timestamp when the last secret expiry notification was dispatched for this secret

expiryprocessed BIT 3 0

Whether the natural expiry of the secret has been processed (0 = not processed, which includes secrets that have not yet expired; 1 = processed)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
oautservcliesecr_cli_ix Performance Asc clientidentifier
oautservcliesecr_expexp_ix Performance Asc/Asc expiryprocessed + expirytime

Relationships