Table JiveCore900.public.jiveoauthpairing Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
oauthpairingid int8 19
userid int8 19
jiveuser.userid Implied Constraint R
providernamehash int4 10
pairingsubtypeid varchar 48
displayname varchar 255
onetimecode varchar 24  √  null
activationdate int8 19  √  null
expirationdate int8 19  √  null
creationdate int8 19
modificationdate int8 19
temppasscodeencoded varchar 255  √  null

Table contained 0 rows at Fri Jan 13 13:20 PST 2017

Column(s) Type Sort Constraint Name Anomalies
oauthpairingid Primary key Asc jiveoauthpr_pk  
expirationdate + activationdate Performance Asc/Asc jiveoauthprexp_idx  
onetimecode Must be unique Asc jiveoauthprotc_idx This unique column is also nullable
userid + providernamehash Performance Asc/Asc jiveoauthprusr_idx  

Close relationships: