BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_STATS - Statistics information matched (e.g., known, mapped, irrelevant)

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 varchar2 10  √  null Statistics type (e.g., Add/Remove, EXE)
INVENTORY_ID number 18  √  null Inventory ID for the statistics
TASK_ID number 18  √  null Task ID for the statistics
TOTAL float 126  √  null Total number of add/remove/exe
KNOWN float 126  √  null Total known addremove/exe
MAPPED float 126  √  null Total mapped addremove/exe
IRRELEVANT float 126  √  null Total irrelavant add/remove/exe
KNOWN_PERC float 126  √  null Total known percentage of add/remove/exe
UNKNOWN float 126  √  null Total unknown of add.remove/exe
UNKNOWN_PERC float 126  √  null Total unknown percentage of add/remove/exe
DATASRC nvarchar2 25  √  null Data Source for this row (e.g., SCCM, ADDM)

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
INVENTORY_ID + TASK_ID + TYPE Primary key Asc/Asc/Asc PK_MATCH_STATS These unique columns are also nullable
Confidential and Proprietary to BDNA