SchemaSpy - Table db_700clean.public.jivestoragecontainer

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

exstoragecontainerid

int8

19

jivestorageattachment.exstoragecontainerid	jivestorageatt_container_fk R
jivestoragefile.exstoragecontainerid	jivestoragefile_container_fk R
jivestoragemember.exstoragecontainerid	jivestoragemem_container_fk R
jivestoragepreview.exstoragecontainerid	jivestoragepre_container_fk R

creationdate

int8

19

modificationdate

int8

19

jivecontainerid

int8

19

jivecontainertype

int4

10

exstorageinstanceid

int8

19

jivestorageinstance.instanceid

jivestoragecon_insid_fk R

state

int4

10

√

null

externalid

varchar

128

√

null

containerconfig

text

2147483647

√

null

permsancestor

int8

19

√

null

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
exstoragecontainerid	Primary key	Asc	exstoragecontainer_pk
jivecontainerid + jivecontainertype	Must be unique	Asc/Asc	exstoragecontainer_cont_idx