BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_DEDUPING_STATS - Row counts of mismatch statistics between source and published data

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 number 18  √  null
MATCH_INVENTORY.INVENTORY_ID FK0_DISC_DEDUP_STATS R
Inventory ID
TASK_ID number 18  √  null
MATCH_TASK_DET.TASK_ID FK1_DISC_DEDUP_STATS R
Task ID
NO_OF_EXTRACTED_MACHINES number 0  √  null No. Of Extracted Machines
NO_OF_DUP_HOST_NAMES number 0  √  null No. Of duplicate host names
NO_OF_MACHINES_WO_HARDWARE number 0  √  null No. Of Machines without HW info
TOTAL_NORM_MACHINES number 0  √  null Total Normalized machines

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
INVENTORY_ID + TASK_ID Primary key Asc/Asc PK_DISC_DEDUPING_STATS These unique columns are also nullable

Close relationships  within of separation:
Confidential and Proprietary to BDNA