Table sem5.dbo.PATTERN
Keeps the content versions that the clients are using

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
PATTERN_IDX char 32
CLIENT_MONIKER varchar 40 ('') Moniker for this content
PATTERN_TYPE nvarchar 256 ('') Virus definition = VIRUS_DEFS
DECABI
DEUCE_SIG
ERASER_ENGINE
PTS_CONTENT
PTS_ENGINE
SYKNAPPS_CAL
SYKNAPPS_ENGINE
SYKNAPPS_WHITELIST
SEQUENCE int 4 ((0)) Sequence number associated with this definition
PATTERNDATE datetime 16,3 ('19700101') Date when this content was released
REVISION int 4 ((0)) Revision number for this content
VERSION varchar 255 ('') Version number for this content
INSERTDATETIME datetime 16,3 ('19700101') Time when this pattern information was entered into the database
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
PATTERN_IDX Primary key Asc PK_PATTERN
CLIENT_MONIKER + PATTERN_IDX Performance Asc/Asc I_PATTERN_CMONIKER
PATTERN_IDX + PATTERN_TYPE + VERSION + CLIENT_MONIKER Performance Asc/Asc/Asc/Asc I_PATTERN_MONIKER
PATTERN_TYPE + DELETED + VERSION Performance Asc/Asc/Asc I_PATTERN_PATTERN_TYPE_PLUS
SEQUENCE Performance Asc I_PATTERN_SEQUENCE