Table JiveCore800.public.jiveimage 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
imageid int8 19
jivedraftimage.imageid jivedi_iid_fk R
jiveimageversion.imageid jiv_iid_fk R
jivepaletteimage.imageid Implied Constraint R
objecttype int4 10
objectid int8 19  √  null
filename varchar 255
filesize int4 10
contenttype varchar 50
creationdate int8 19
modificationdate int8 19
active int2 5 1

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name
imageid Primary key Asc jiveimage_pk
objecttype + objectid Performance Asc/Asc jvimg_objt_idx

Close relationships  within of separation: