BDNA Discover Publish version 7.7.0 with 201605 Sequence
BDNA_SW_PRODUCT_INFO - Software Product Information [Columns Deprecated: Category 1 (Old), Category 2 (Old). Replaced by: Category 1 (2012), Category 2 (2012)]

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
SW_MD_ID number 22 Software MarketData Id
MANUFACTURER varchar2 256  √  null Manufacturer
PRODUCT_FAMILY varchar2 256  √  null Product Family
PRODUCT_NAME varchar2 256  √  null Product Name
EDITION varchar2 256  √  null Edition
PRODUCT_COMPONENT varchar2 256  √  null Product Component
VERSION varchar2 256  √  null Version
MARKET_VERSION varchar2 256  √  null Market Version
UNVERIFIED_VERSION varchar2 3  √  null unverified_version
LICENSABLE varchar2 256  √  null Is Licensable?
GA_DATE varchar2 256  √  null GA Date
CATEGORY1 varchar2 256  √  null Category 1 (Old)
CATEGORY2 varchar2 256  √  null Category 2 (Old)
CATEGORY1_2012 varchar2 256  √  null Category 1 (2012)
CATEGORY2_2012 varchar2 256  √  null Category 2 (2012)
VENDOR_CATEGORY varchar2 256  √  null Vendor Category
EXPR_WIN7COMPAT_32 varchar2 256  √  null Windows 7 Compatibility(32-Bit)
WIN7ACTION_32 varchar2 256  √  null Windows 7 Compatibilty Action(32-Bit)
WIN7UP_32 varchar2 256  √  null Windows 7 Upgrade Path(32-Bit)
EXPR_WIN7COMPAT_64 varchar2 256  √  null Windows 7 Compatibility(64-Bit)
WIN7ACTION_64 varchar2 256  √  null Windows 7 Compatibility Action(64-Bit)
WIN7UP_64 varchar2 256  √  null Windows 7 Upgrade Path(64-Bit)
SW_PRODUCT_ID number 22
BDNA_INV_CATALOG_MAP.SW_PRODUCT_ID BDNAINVCATALOGMA_SW_PRODUCT_ID R
Software Product Id

Analyzed at Sat Mar 05 19:14 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
SW_PRODUCT_ID Primary key Asc PK_BDNA_SW_PRODUCT_INFO

Close relationships  within of separation:
Confidential and Proprietary to BDNA