Table JiveCore700.public.jiveoauthstore 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
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

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
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: