Table JiveCore700.public.jiveextension 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
extensionid int8 19
jiveextensionalert.extensionid jvextalt_impextid_fk R
jiveextensioni18n.extensionid jvexti18n_impextid_fk R
jiveextensiontag.extensionid jvexttag_impextid_fk R
jiveoauth2client.extensionid oauth2client_fk R
extensionuuid varchar 128
authordata varchar 255
definition text 2147483647  √  null
metadata text 2147483647  √  null
serviceurl varchar 1024
tenancyuri varchar 256  √  null
targetconfig varchar 4000  √  null
name varchar 255
jiveproperty.name Implied Constraint R
description varchar 255
deployerid int8 19  √  null
jiveuser.userid jvext_impexpid_fk R
deploydate int8 19  √  null
publisheduuid varchar 128  √  null
publishedversionid int8 19  √  null
publishedclientid varchar 127  √  null
publishedclientsecret varchar 127  √  null
removable int2 5 1
status varchar 25 ''::character varying
type varchar 25
pluginsourcesha1 varchar 48  √  null
visibletouserid int8 19  √  null
creationdate int8 19
modificationdate int8 19

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
extensionid Primary key Asc jvext_pk
extensionuuid Must be unique Asc jvext_uuid_idx

Close relationships  within of separation: