Tables
Constraints
Columns
BDNA Data Platform 5.4 July 2017 (SQL Server)
MATCH_PER_EXE_STAT_SUMM - EXE Stats Summary table
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
TASK_ID
numeric
20
Task ID
CAT_KEYWORD_TIER
numeric
20
√
null
Tier 1, or 3 of Manufacturer
CAT_MANUFACTURER_ID
numeric
20
√
null
Unique Catalog identifier of Manufacturer
TOTAL
float
8
√
null
Number of Instances of the manufacturer
MAPPED
float
8
√
null
Total Number of records Mapped
IRRELEVANT
float
8
√
null
Total Number of records Irrelevant
KNOWN
float
8
√
null
Total Number of records Known
PERC_KNOWN
float
8
√
null
Total Number of records Percoentage Known
UNKNOWN
float
8
√
null
Total Number of records UnKnown
PERC_UNKNOWN
float
8
√
null
Total Number of records Percoentage UnKnown
Analyzed at Thu Jul 20 12:14 PDT 2017
Confidential and Proprietary to BDNA