Table JiveCore900.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
jiveretentionimage.imageid Implied Constraint R
objecttype int4 10
objectid int8 19  √  null
spremotedoctranslation.objectid Implied Constraint R
filename varchar 255
filesize int4 10
contenttype varchar 50
creationdate int8 19
modificationdate int8 19
active int2 5 1
userid int8 19 '-1'::integer
jiveuser.userid Implied Constraint R

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

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: