# oauth2_issuer

0 rows

### Description

Details for an oauth 2 connect identity issuer.

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
auth_oauth2_linked_login.issuerid | authoautlinklogi_iss2_fkR
badge_backpack_oauth2.issuerid | badgbackoaut_iss2_fkR
badge_external_backpack.oauth2_issuerid | badgexteback_oau2_fkR
oauth2_access_token.issuerid | oautaccetoke_iss_fkR
oauth2_endpoint.issuerid | oautendp_iss2_fkR
oauth2_refresh_token.issuerid | oautrefrtoke_iss2_fkR
oauth2_system_account.issuerid | oautsystacco_iss_fkR
oauth2_user_field_mapping.issuerid | oautuserfielmapp_iss2_fkR
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
name | VARCHAR | 255 |  |  |  |  |  | The name of this identity issuer
image | LONGTEXT | 2147483647 |  |  | null |  |  |
baseurl | LONGTEXT | 2147483647 |  |  | null |  |  | The base url to the issuer
clientid | LONGTEXT | 2147483647 |  |  | null |  |  | The client id used to connect to this oauth2 service.
clientsecret | LONGTEXT | 2147483647 |  |  | null |  |  | The secret used to connect to this oauth2 service.
loginscopes | LONGTEXT | 2147483647 |  |  | null |  |  | The scopes requested for a normal login attempt.
loginscopesoffline | LONGTEXT | 2147483647 |  |  | null |  |  | The scopes requested for a login attempt to generate a refresh token.
loginparams | LONGTEXT | 2147483647 |  |  | null |  |  | Additional parameters sent for a login attempt.
loginparamsoffline | LONGTEXT | 2147483647 |  |  | null |  |  | Additional parameters sent for a login attempt to generate a refresh token.
alloweddomains | LONGTEXT | 2147483647 |  |  | null |  |  | Allowed domains for this issuer.
scopessupported | LONGTEXT | 2147483647 | √ |  | null |  |  | The list of scopes this service supports.
enabled | TINYINT | 3 |  |  | 1 |  |  |
showonloginpage | TINYINT | 3 |  |  | 1 |  |  |
basicauth | TINYINT | 3 |  |  | 0 |  |  | Use HTTP Basic authentication scheme when sending client ID and password
sortorder | BIGINT | 19 |  |  | null |  |  | The defined sort order.
requireconfirmation | TINYINT | 3 |  |  | 1 |  |  |
servicetype | VARCHAR | 255 | √ |  | null |  |  | Issuer service type, such as 'google' or 'facebook'.
loginpagename | VARCHAR | 255 | √ |  | null |  |  |
systememail | VARCHAR | 100 | √ |  | null |  |  | The email that will be used connect system account for sending email via SMTP

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id

### Relationships