Table JiveCore900.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
jivepermmask.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'::integer
jivecarouselcontainer.containerid Implied Constraint R
status int4 10

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

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: