BDNA Discover Publish version 7.7.2 with 201708
BDNA_DB2_INSTALLS - IBM DB2 Installations

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
DB2INSTALLATION_LABEL varchar2 256  √  null Installation Directory
VERSION varchar2 256  √  null DB2 Version
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNADB2INSTALLS R
Operating Systems Id
DB2INSTALLATION_ID number 22
BDNA_DB2_FEATURES.DB2INSTALLATION_ID FKM2_BDNADB2FEATURES R
BDNA_DB2_LICMLIST.DB2INSTALLATION_ID FKM2_BDNADB2LICMLIST R
BDNA_INV_CATALOG_MAP.INV_ASSET_ID FKM1_BDNADB2INSTALLS R
DB2 Installation Id
INVENTORY_ID number 22 -1
BDNA_DB2_FEATURES.INVENTORY_ID FKM2_BDNADB2FEATURES R
BDNA_DB2_LICMLIST.INVENTORY_ID FKM2_BDNADB2LICMLIST R
BDNA_INVENTORY_INFO.INVENTORY_ID BDNADB2INSTALLS0_INVENTORY_ID R
BDNA_INV_CATALOG_MAP.INVENTORY_ID FKM1_BDNADB2INSTALLS R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNADB2INSTALLS R
Inventory Id

Analyzed at Wed Jul 12 12:54 CST 2017

Indexes:
Column(s) Type Sort Constraint Name
DB2INSTALLATION_ID + INVENTORY_ID Primary key Asc/Asc PK_BDNA_DB2_INSTALLS

Close relationships  within of separation:
Confidential and Proprietary to BDNA