Table sem5.dbo.HPP_APPLICATION
Keeps applications detected by TruScan

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
APP_IDX char 32
APP_HASH varchar 64 HASH for this application
HASH_TYPE tinyint 1 ((1)) HASH algorithm used:
0 = MD5
1 = SHA-1
2 = SHA-256
COMPANY_NAME nvarchar 520 ('') Company name
APP_NAME nvarchar 520 ('') Application name
APP_VERSION nvarchar 512 ('') Application version
APP_TYPE int 4 ((-1)) Application type:
0 = Trojan worm
1 = Trojan worm
2 = Key logger
100 = Remote control
FILE_SIZE bigint 8 ((0)) File size
DETECTION_TYPE tinyint 1 ((0)) Detection type:
0 = heuristic
1 = commercial application
USN bigint 8 ((1)) A USN-based serial number; this ID is not unique.
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
HELP_VIRUS_IDX char 32  √  null Foreign key to VIRUS table which provides help ID for online Symantec write-up
FIRST_SEEN bigint 8 ((0)) The first seen date for the convicted application
Default is 0.

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
APP_IDX Primary key Asc PK_HPP_APPLICATION
APP_HASH Performance Asc I_HPP_APPLICATION_APP_HASH