BDNA Data Platform 5.4 July 2017 (Oracle)
TECHNOPEDIA_COVERAGE - Internal Technopedia 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
SUBSCRIPTION_ID number 0
FILTER_BY_TAXONOMY varchar2 1  √  null
CAT_TAXONOMY_IDS varchar2 256  √  null
FILTER_BY_HW_MFG varchar2 1  √  null
CAT_HW_MFG_IDS varchar2 256  √  null
FILTER_BY_SW_MFG varchar2 1  √  null
CAT_SW_MFG_IDS varchar2 256  √  null
FILTER_BY_SW_PDT varchar2 1  √  null
CAT_SW_PRODUCT_IDS varchar2 256  √  null
FILTER_BY_HW_PDT varchar2 1  √  null
CAT_HW_PRODUCT_IDS varchar2 256  √  null
FILTER_BY_HW_MODEL varchar2 1  √  null
CAT_HW_MODEL_IDS varchar2 256  √  null
INVENTORY_ID number 18

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
SUBSCRIPTION_ID + INVENTORY_ID Primary key Asc/Asc TECHNOPEDIA_COVERAGE_PK
Confidential and Proprietary to BDNA