jiveoauthtoken

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
oauthtokenid int8 19 null
jiveoauthaccesslog.oauthtokenid jiveoauthacc_fkR
jiveoauthpasscode.oauthtokenid jiveoauthpass_fkR
userid int8 19 null
clientid varchar 64 null
clientsecret varchar 127 √ null
refreshtoken varchar 127 √ null
accesstoken varchar 127 √ null
accesstokenexp int8 19 √ null
apiaccessorid int8 19 null
expirationdate int8 19 √ null
creationdate int8 19 null
modificationdate int8 19 null
sessionid varchar 64 √ null

Indexes

Constraint Name Type Sort Column(s)
jiveoatoken_pk Primary key Asc oauthtokenid
jiveoaacctoken_idx Must be unique Asc accesstoken
jiveoaclientid_idx Must be unique Asc clientid
jiveoaexpdate_idx Performance Asc expirationdate
jiveoareftoken_idx Must be unique Asc refreshtoken
jiveoatsess_idx Performance Asc/Asc userid + sessionid

Relationships

Close relationships within degrees of separation