Tables
Constraints
Columns
BDNA Data Platform 5.4 July 2017 (SQL Server)
MATCH_ADDREMOVE_TIER_STAT_SUMM - Add/Remove summary by tier
Related columns
Constraints
Comments
Legend
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
CAT_KEYWORD_TIER
numeric
20
√
null
Tier from Catalog
TOTAL
float
8
√
null
Total count for each manufacturer/tier/category
MAPPED
float
8
√
null
Total Add/Remove mapped records
IRRELEVANT
float
8
√
null
Total Add/Remove irrelevant records
KNOWN
float
8
√
null
Total Add/Remove known records
PERC_KNOWN
float
8
√
null
Total Add/Remove percentage known records
UNKNOWN
float
8
√
null
Total Add/Remove unknown records
PERC_UNKNOWN
float
8
√
null
Total Add/Remove percentage unknown records
DATASRC
nvarchar
50
√
null
Data Source for this row (e.g., SCCM, ADDM)
Analyzed at Thu Jul 20 12:14 PDT 2017
Confidential and Proprietary to BDNA