Table JiveCore900.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
name varchar 255
jivepermmask.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 10 rows at Fri Jan 13 13:20 PST 2017

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: