Table sem5.dbo.INVENTORYCURRENTRISK1
Keeps the client to infected threat events mapping

Generated by
SchemaSpy
Legend:
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
COMPUTER_IDX char 32
FILE_KEY char 32
FIRST_INFECTED_TIME bigint 8 ((0)) Time that the unremediated risk was first detected
SOURCE varchar 50 ('') Type of scan that detected the risk
SCAN_TIME bigint 8 ((0)) Last scan time
FILENAME nvarchar 510 ('') Risk file name
SHA256 char 64 Risk file SHA-256
VIRUSNAME_IDX char 32 ('') Foreign key to VIRUS table
DEFDATE int 4 ((0)) AV definition date used during last scan
USN bigint 8 ((1)) Update serial number; used to detect data change.
TIME_STAMP bigint 8 ((0)) The time when the event is logged into system (GMT), which is server side time
DELETED tinyint 1 ((0)) Deleted row; 0 = Not Deleted, 1 = Deleted
LOGON_USER nvarchar 512  √  null User who was logged on when risk was first detected

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
COMPUTER_IDX + FILE_KEY Primary key Asc/Asc PK_INVENTORYCURRENTRISK1