oauth2_access_token

0 rows


Description

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

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
user.id oautaccetoke_use2_fkR

The user who modified this record.

issuerid BIGINT 19 null
oauth2_issuer.id oautaccetoke_iss_fkR

Corresponding oauth2 issuer

token LONGTEXT 2147483647 null

access token

expires BIGINT 19 null

Expiry timestamp (according to the issuer)

scope LONGTEXT 2147483647 null

Indexes

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

Relationships