Table JiveCore700.public.jivecommunity 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
communityid int8 19
jivecommunityprop.communityid jcp_cid_fk R
jivegateway.communityid Implied Constraint R
name varchar 255
jiveproperty.name Implied Constraint R
displayname varchar 255
description varchar 1000  √  null
creationdate int8 19
modificationdate int8 19
lft int4 10
rgt int4 10
localecode varchar 32  √  null
workflowid int8 19  √  null
status int4 10

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
communityid Primary key Asc jivecommunity_pk
lft Performance Asc jvcmmnty_lft_idx
rgt Performance Asc jvcmmnty_rgt_idx

Close relationships: