Table JiveCore700.public.jiveblog 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
blogid int8 19
jiveblogpost.blogid jivebpst_bid_fk R
jiveblogprop.blogid jivebprp_bid_fk R
name varchar 255
jiveproperty.name Implied Constraint R
displayname varchar 255  √  null
description varchar 1000  √  null
creationdate int8 19
modificationdate int8 19
cmauthentication int2 5  √  null
feedenabled int2 5  √  null
feedfullcontent int2 5  √  null
pingoverride int2 5  √  null
pingservices text 2147483647  √  null
containertype int4 10 17
containerid int8 19 (-2)
jivecarouselcontainer.containerid Implied Constraint R
status int4 10

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
blogid Primary key Asc jiveblog_pk
containerid + containertype Performance Asc/Asc jiveblg_ctid_idx
displayname Performance Asc jiveblg_d_idx

Close relationships  within of separation: