Table sbs6a.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

Table contained 3 rows at Fri Aug 24 10:15 PDT 2012

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: