# oauth2_system_account

0 rows

### Description

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

### 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