jiveimage

106 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
imageid int8 19 null
jivedraftimage.imageid jivedi_iid_fkR
jiveimageversion.imageid jiv_iid_fkR
objecttype int4 10 null
objectid int8 19 √ null
filename varchar 255 null
filesize int4 10 null
contenttype varchar 50 null
creationdate int8 19 null
modificationdate int8 19 null
active int2 5 1
userid int8 19 (-1)

Indexes

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

Relationships

Close relationships within degrees of separation