Table sem5.dbo.VIRUSCATEGORY
Lists and defines all possible kinds of threats

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
DYNAUBER int 4 Uber category ID
DYNACAT int 4 Sub-category ID
LOCALE int 4 ((0)) Locale integer
TRANSLATION nvarchar 510 ('') Translated name
CATEGORY_DESC nvarchar 510 ('') Category description, Category_Desc (English string key used for lookup)
0 = Viral
1 = Non-Viral malicious
2 = Malicious
3 = Heuristic
/* 4 = Security risk */
5 = Hack tool
6 = Spyware
7 = Trackware
8 = Dialer
9 = Remote access
10 = Adware
11 = Jokeware
12 = Client compliancy
13 = Generic load point
14 = ApplicationHeuristic
15 = Cookie
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

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
DYNAUBER + DYNACAT + LOCALE Primary key Asc/Asc/Asc PK_VIRUSCATEGORY