oauth2_system_account

0 rows


Description

Stored details used to get an access token as a system user

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 oautsystacco_use2_fkR

The user who modified this record.

issuerid BIGINT 19 null
oauth2_issuer.id oautsystacco_iss_fkR

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.

Indexes

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

Relationships