Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| oauthpairingid | int8 | 19 | null |
|
|
|||
| userid | int8 | 19 | null |
|
|
|||
| providernamehash | int4 | 10 | null |
|
|
|||
| pairingsubtypeid | varchar | 48 | null |
|
|
|||
| displayname | varchar | 255 | null |
|
|
|||
| onetimecode | varchar | 24 | √ | null |
|
|
||
| activationdate | int8 | 19 | √ | null |
|
|
||
| expirationdate | int8 | 19 | √ | null |
|
|
||
| creationdate | int8 | 19 | null |
|
|
|||
| modificationdate | int8 | 19 | null |
|
|
|||
| temppasscodeencoded | varchar | 255 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| jiveoauthpr_pk | Primary key | Asc | oauthpairingid |
| jiveoauthprexp_idx | Performance | Asc/Asc | expirationdate + activationdate |
| jiveoauthprotc_idx | Must be unique | Asc | onetimecode |
| jiveoauthprusr_idx | Performance | Asc/Asc | userid + providernamehash |
Diagram producer might be missing
No diagrams were produced please see application output for any errors