Table JiveCore900.public.jiveoauthstore 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
userid int8 19
jiveuser.userid jiveoauth_user_fk R
version int2 5
instanceappid int8 19
jiveinstanceapp.instanceappid jiveoauth_appid_fk R
contextid int8 19  √  null
jiveextcontext.contextid Implied Constraint R
servicename varchar 64
tokenname varchar 64
tokenvalue varchar 1024
tokensecret varchar 1024
expiration int8 19  √  null
creationdate int8 19

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

Column(s) Type Sort Constraint Name
userid + version + instanceappid + servicename + tokenname Primary key Asc/Asc/Asc/Asc/Asc jiveoauth_key_idx

Close relationships  within of separation: