Table JiveCore800.public.jiveoauthtoken Generated by
SchemaSpy
Legend: SourceForge.net
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
oauthtokenid int8 19
jiveoauthaccesslog.oauthtokenid jiveoauthacc_fk R
jiveoauthpasscode.oauthtokenid jiveoauthpass_fk R
userid int8 19
jiveuser.userid Implied Constraint R
clientid varchar 64
clientsecret varchar 127  √  null
refreshtoken varchar 127  √  null
accesstoken varchar 127  √  null
accesstokenexp int8 19  √  null
apiaccessorid int8 19
expirationdate int8 19  √  null
creationdate int8 19
modificationdate int8 19
sessionid varchar 64  √  null

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name Anomalies
oauthtokenid Primary key Asc jiveoatoken_pk  
accesstoken Must be unique Asc jiveoaacctoken_idx This unique column is also nullable
clientid Must be unique Asc jiveoaclientid_idx  
expirationdate Performance Asc jiveoaexpdate_idx  
refreshtoken Must be unique Asc jiveoareftoken_idx This unique column is also nullable
userid + sessionid Performance Asc/Asc jiveoatsess_idx  

Close relationships: