Table JiveCore900.public.jiveavscanrecord Generated by
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
antivirusid int8 19
objectid int8 19
spremotedoctranslation.objectid Implied Constraint R
objecttype int4 10
statusid int4 10
violations varchar 255  √  null
scancount int4 10
scanrequestdate int8 19
lastscandate int8 19
lastsuccessdate int8 19

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

Column(s) Type Sort Constraint Name
antivirusid Primary key Asc javsr_id_idx
objectid + objecttype Must be unique Asc/Asc javsr_obj_idx
statusid Performance Asc javsr_sts_idx

Close relationships: