oauth2_refresh_token

0 rows


Description

Stores refresh tokens which can be exchanged for access toke

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
timecreated BIGINT 19 null

Time this record was created.

timemodified BIGINT 19 null

Time this record was modified.

userid BIGINT 19 null
user.id oautrefrtoke_use2_fkR

The user to whom this refresh token belongs.

issuerid BIGINT 19 null
oauth2_issuer.id oautrefrtoke_iss2_fkR

Corresponding oauth2 issuer

token LONGTEXT 2147483647 null

refresh token

scopehash VARCHAR 40

sha1 hash of the scopes used when requesting the refresh token

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
oautrefrtoke_iss4_ix Performance Asc issuerid
oautrefrtoke_use4_ix Performance Asc userid
oautrefrtoke_useisssco2_uix Must be unique Asc/Asc/Asc userid + issuerid + scopehash

Relationships