Table JiveCore700.public.jiveoauth2code 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
oauthcodeid int8 19
jivewebhook.oauthcodeid jivewebhookoauth2_fk R
userid int8 19
jiveuser.userid jvoauth2codeusr_fk R
oauthclientid int8 19
jiveoauth2client.oauthclientid jvoauth2codeclnt_fk R
value varchar 128
valuetype int2 5
scope varchar 1000  √  null
redirecturi varchar 2000  √  null
relatedid int8 19  √  null
expirationdate int8 19
creationdate int8 19
modificationdate int8 19

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
oauthcodeid Primary key Asc jvoauth2code_pk
expirationdate Performance Asc jvoauth2codeexp_idx
userid Performance Asc jvoauth2codeusr_idx
value Must be unique Asc jvoauth2codeval_idx

Close relationships  within of separation: