BDNA Data Platform 5.4 July 2017 (SQL Server)
MATCH_ADDREMOVE_MANF_KWD - Add/Remove Manufacturer to key word mapping table

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 numeric 20 Inventory ID for this row
TASK_ID numeric 20 Task ID for this row
ADDREMOVE_ID varchar 100  √  null Unqiue Addremove Indentifier
CATEGORY nvarchar 20  √  null Category (e.g., Mapped, Irrelevant, UnKnown)
PRODID nvarchar 2048  √  null PRODID from this add/remove (e.g., {18C71DD4-0147-4318-8689-AE836278FBFE})
DISPLAY_NAME nvarchar 2048  √  null Display name for add/remove (e.g., Mobile Broadband Drivers, PGP Desktop)
PUBLISHER nvarchar 2048  √  null Publisher for add/remove (e.g., Core Services, Trend Micro)
VERSION nvarchar 2048  √  null Add/remove version (e.g., 1.5.3, 5.10.4803.0)
CAT_KEYWORD_ID int 4  √  null Unique Keyword ID from Catalog
CAT_KEYWORD_TIER int 4  √  null Tier from Catalog
CAT_MANUFACTURER_ID numeric 20  √  null Manufactuer from Catalog
CAT_KEYWORD varchar 255  √  null Keyword that matched the manufacturer from the Catalog

Analyzed at Thu Jul 20 12:14 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
INVENTORY_ID + TASK_ID + ADDREMOVE_ID Performance Asc/Asc/Asc MATCH_ADDREMOVE_MANF_KWD_IDX
Confidential and Proprietary to BDNA