Table JiveCore700.public.jivewebhook 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
hookid int8 19
jivewebhookqueue.hookid jivewebhookqueue_fk R
userid int8 19
jiveuser.userid Implied Constraint R
listenas int8 19
url varchar 2000
jivewebhooklocks.url Implied Constraint R
oauthcodeid int8 19
jiveoauth2code.oauthcodeid jivewebhookoauth2_fk R
enabled int2 5
internal int2 5
buggy int2 5
buggydate int8 19  √  null
bugdetail varchar 3500  √  null
connectiontimeout int4 10  √  null
readtimeout int4 10  √  null
types varchar 2000  √  null
typesmd5 varchar 48  √  null
containertype int4 10
containerid int8 19
jivecarouselcontainer.containerid Implied Constraint R
objecttype int4 10  √  null
objectid int8 19  √  null
fields varchar 2000  √  null
creationdate int8 19
modificationdate int8 19

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
hookid Primary key Asc jivewebhook_pk
buggy Performance Asc jivewebhook_buggy_idx
objecttype + objectid + userid Performance Asc/Asc/Asc jivewebhook_instance_idx
internal Performance Asc jivewebhook_internal_idx
containertype + containerid + objecttype + objectid + typesmd5 + userid Must be unique Asc/Asc/Asc/Asc/Asc/Asc jivewebhook_unique_idx

Close relationships  within of separation: