Oauth2 System Account Table Schema (oauth2_system_account)


Stored details used to get an access token as a system user for this oauth2 service.

oauth2_system_account 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

The id of the oauth 2 identity issuer

refreshtoken LONGTEXT 2147483647 null

The refresh token used to request access tokens.

grantedscopes LONGTEXT 2147483647 null

The scopes that this system account has been granted access to.

email LONGTEXT 2147483647 null

The email that was connected to this issuer.

username LONGTEXT 2147483647 null

The username that was connected as a system account to this issue.

Table contained -1 rows

oauth2_system_account table indexes

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