0 rows


Stores refresh tokens which can be exchanged for access toke


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


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
oautrefrtoke_iss_ix Performance Asc issuerid
oautrefrtoke_use_ix Performance Asc userid
oautrefrtoke_useisssco_uix Must be unique Asc/Asc/Asc userid + issuerid + scopehash