Table sem5.dbo.SCFINVENTORY
Not used.

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
AGENT_ID char 32
IPSSIGDATE datetime 16,3  √  (NULL) Date of IPS signature
IPSSIGREV int 4  √  (NULL) Revision of IPS signature
SCFVERSION varchar 255 ('') Firewall version
SCFPOLICYFILE nvarchar 510 ('')
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
AGENT_ID Primary key Asc PK_SCFINVENTORY