SchemaSpy - Table dba800.public.jiveblog

Generated by
SchemaSpy

Legend:

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 Mon Apr 27 15:32 PDT 2015

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