Table JiveCore800.public.jiveavscanrecord 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
antivirusid int8 19
objectid int8 19
objecttype int4 10
statusid int4 10
violations varchar 255  √  null
scancount int4 10
scanrequestdate int8 19
lastscandate int8 19
lastsuccessdate int8 19

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:
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