Table BDNA_PUBLISH.dbo.MATCH_ALL_EXE
Has Matched Exe information

 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
INVENTORY_ID float 8
MATCH_INVENTORY.INVENTORY_ID FK0_MATCH_ALL_EXE R
Inventory Id for this row
TASK_ID float 8
MATCH_TASK_DET.TASK_ID FK1_MATCH_ALL_EXE R
Task Id for this row
CATEGORY varchar 10  √  null Category eg: Mapped,Irrelevant,UnKnown
FILE_ID numeric 20 File Id
FILE_NAME varchar 1024  √  null File name eg: AvDSGlobalCatalog.exe
FILE_DESCRIPTION varchar 2000  √  null File description eg: AvExtractSvr Module
FILE_VERSION varchar 512  √  null File version eg: 4, 0, 5, 80
FILE_SIZE varchar 64  √  null File size
COMPANY_NAME varchar 1024  √  null company name eg: Cisco Systems, Inc.
PRODUCT_NAME varchar 1024  √  null Product name eg: AvNotifier Executable, AvPostProcSvr Module
PRODUCT_VERSION varchar 512  √  null Product version eg: 4.0(5)
PRODUCT_LANGUAGE varchar 256  √  null Product Language
REASONS varchar 1024  √  null Reasons
UNKNOWN_INSTANCES numeric 20  √  null

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
INVENTORY_ID + TASK_ID + FILE_ID Primary key Asc/Asc/Asc PK_MATCH_ALL_EXE

Close relationships  within of separation: