BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_ALL_ADDREMOVE - AddRemove information matched

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_MATCH_ALL_ADDREMOVE R
Inventory ID for this row
TASK_ID number 18  √  null
MATCH_TASK_DET.TASK_ID FK1_MATCH_ALL_ADDREMOVE R
Task ID for this row
CATEGORY nvarchar2 10  √  null Category (e.g., Mapped, Irrelevant, Unknown
DISPLAY_NAME nvarchar2 1024  √  null Display name for add/remove (e.g., Mobile Broadband Drivers, PGP Desktop)
PUBLISHER nvarchar2 1024  √  null Publisher for add/remove (e.g., Core Services, Trend Micro)
VERSION nvarchar2 1024  √  null Addremove version (e.g., 1.5.3, 5.10.4803.0)
REASONS nvarchar2 1024  √  null Reasons for add/remove
NUM_OF_INSTANCES number 0  √  null Number of instances of Addremove
ADDREMOVE_ID nvarchar2 32  √  null Unqiue Addremove Indentifier

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
INVENTORY_ID + TASK_ID + ADDREMOVE_ID Performance Asc/Asc/Asc MATCH_ALL_ADDREMOVE_IDX

Close relationships  within of separation:
Confidential and Proprietary to BDNA