Table JiveCore900.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
jiveextensioncert.extensionid jvextcrt_extid_fk R
jiveextensiongroup.extensionid jiveextgrp_ext_fk R
jiveextensioni18n.extensionid jvexti18n_impextid_fk R
jiveextensiontag.extensionid jvexttag_impextid_fk R
jiveoauth2client.extensionid oauth2client_fk R
extensionuuid varchar 128
authordata varchar 2048
definition text 2147483647  √  null
metadata text 2147483647  √  null
serviceurl varchar 1024
tenancyuri varchar 256  √  null
targetconfig varchar 4000  √  null
name varchar 255
jivepermmask.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
allowupdates int2 5 0
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
visibletoexternalcontributors int2 5 0
publicresourcehash varchar 64  √  'null'::character varying

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

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: