BDNA Data Platform 5.4 July 2017 (SQL Server)
MATCH_SW_ALL_INV_V

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
CAT_SW_RELEASE_ID numeric 20  √  null
CAT_SW_EDITION_ID numeric 20  √  null
CAT_SW_VERSION_ID numeric 20  √  null
CAT_SW_VERSION_GROUP_ID numeric 20  √  null
CAT_SW_PRODUCT_ID numeric 20  √  null
CAT_TAXONOMY2012_ID numeric 20  √  null
CAT_TAXONOMY_CATEGORY1 varchar 256  √  null
CAT_TAXONOMY_CATEGORY2 varchar 256  √  null
CAT_MANUFACTURER varchar 255  √  null
CAT_VERSION_GROUP varchar 64  √  null
CAT_VERSION varchar 64  √  null
CAT_PATCHLEVEL varchar 64  √  null
CAT_EDITION varchar 2000  √  null
CAT_LICENSABLE varchar 50  √  null
SUITE_ID numeric 20  √  null
CAT_SW_UUID numeric 20  √  null

Analyzed at Tue Jul 11 13:32 PDT 2017

View Definition:
CREATE VIEW MATCH_SW_ALL_INV_V AS SELECT * FROM ( SELECT DISTINCT CAT_SW_RELEASE_ID ,CAT_SW_EDITION_ID ,CAT_SW_VERSION_ID ,CAT_SW_VERSION_GROUP_ID ,CAT_SW_PRODUCT_ID ,CAT_TAXONOMY2012_ID ,CAT_TAXONOMY_CATEGORY1 ,CAT_TAXONOMY_CATEGORY2 ,CAT_MANUFACTURER ,CAT_VERSION_GROUP ,CAT_VERSION ,CAT_PATCHLEVEL ,CAT_EDITION ,CAT_LICENSABLE ,SUITE_ID ,CAT_SW_UUID FROM MATCH_HOST_SW_PROD WHERE INVENTORY_ID= INVENTORY_ID AND NULLIF(MATCH_HOST_SW_PROD.SUITE_ID,-1) IS NULL) inv
 
Possibly Referenced Tables/Views:

Confidential and Proprietary to BDNA