SchemaSpy - Table dba800.public.jivestoragemember

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

exstorageid

int8

19

jivedvrevartifact.exstorageid

Implied Constraint R

espid

varchar

512

√

null

exstoragecontainerid

int8

19

jivestoragecontainer.exstoragecontainerid

jivestoragemem_container_fk R

entityid

int8

19

entitytype

int4

10

permission

int4

10

isasyncplaceholder

int2

5

0

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:

Column(s)	Type	Sort	Constraint Name
exstorageid	Primary key	Asc	jivestoragemember_pk
exstoragecontainerid + espid	Performance	Asc/Asc	jivestoragemem_espid_idx
exstoragecontainerid + entityid + entitytype	Performance	Asc/Asc/Asc	jivestoragemem_userid_idx