Table BDNA_PUBLISH.dbo.MATCH_STATS
Has Matched statistics information for Addremove/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
TYPE varchar 10 Statistics type eg: Add/Remove, EXE
INVENTORY_ID float 8 Inventory Id for this statistics
TASK_ID float 8 Task Id for this statistics
TOTAL float 8  √  null Total number of addremove/exe
KNOWN float 8  √  null Total known addremove/exe
MAPPED float 8  √  null Total mapped addremove/exe
IRRELEVANT float 8  √  null Total irrelavant addremove/exe
KNOWN_PERC float 8  √  null Total known percentage of addremove/exe
UNKNOWN float 8  √  null Total unknown of addremove/exe
UNKNOWN_PERC float 8  √  null Total unknown percentage of addremove/exe
DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM

Analyzed at Thu Oct 04 14:29 PDT 2012

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