Oauth2 Access Token Table Schema (oauth2_access_token)


Stores access tokens for system accounts in order to be able to use a single token across multiple sessions

oauth2_access_token table 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.

usermodified BIGINT 19 null

The user who modified this record.

issuerid BIGINT 19 null

Corresponding oauth2 issuer

token LONGTEXT 2147483647 null

access token

expires BIGINT 19 null

Expiry timestamp (according to the issuer)

scope LONGTEXT 2147483647 null

Table contained -1 rows

oauth2_access_token table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
oautaccetoke_iss_uix Must be unique Asc issuerid