BDNA Data Platform 5.4 July 2017 (SQL Server)
MATCH_SW_ALL_INV

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

Indexes:
Column(s) Type Sort Constraint Name
CAT_SW_RELEASE_ID Performance Asc MATCH_SW_ALL_INV_CAT_SW_RELEASE_ID_IDX
Confidential and Proprietary to BDNA