BDNA Discover Publish version 7.7.1 with 201612 Sequence
BDNA_INV_CATALOG_MAP - Inventory Software to Catalog ID Mapping

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
INV_ASSET_ID number 22
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNA_ALL_OS R
BDNA_DB2_FEATURES.DB2INSTALLATION_ID FKM1_BDNADB2FEATURES R
BDNA_DB2_INSTALLS.DB2INSTALLATION_ID FKM1_BDNADB2INSTALLS R
BDNA_DB2_INSTANCES.DB2INSTANCE_ID FKM1_BDNADB2INSTANCE R
BDNA_DB2_LICMLIST.DB2INSTALLATION_ID FKM1_BDNADB2LICMLIST R
BDNA_DB2_LICMLIST.OPERATINGSYSTEM_ID FKM0_BDNADB2LICMLIST R
BDNA_FP_APPS.APPLICATION_ID FKM1_BDNA_FP_APPS R
BDNA_GUARDIUM_MODULES.UNIXGDAM_ID FKM0_BDNAGUARDIUMMOD R
BDNA_IFMX_INSTALLS.INFORMIXINSTALLATION_ID FKM1_BDNAIFMXINSTALL R
BDNA_IFMX_INSTANCES.INFORMIXSERVER_ID FKM1_BDNAIFMXINSTANC R
BDNA_MSSQL_INSTALLS.MSSQLSERVERINSTALLATION_ID FKM1_BDNAMSSQLINSTAL R
BDNA_MSSQL_INSTANCES.MSSQLSERVERINSTANCE_ID FKM1_BDNAMSSQLINSTAN R
BDNA_ORADB_INSTALLS.ORACLEINSTALLATION_ID FKM1_BDNAORADBINSTAL R
BDNA_ORADB_INSTANCES.ORACLEINSTANCE_ID FKM1_BDNAORADBINSTAN R
Inventory Asset Id
SW_SUPPORT_ID number 22  √  null
BDNA_SW_SUPPORT_INFO.SW_SUPPORT_ID BDNAINVCATALOGMA_SW_SUPPORT_ID R
Software Support Id
HW_PRODUCT_ID number 22  √  null
BDNA_HW_PRODUCT_INFO.HW_PRODUCT_ID BDNAINVCATALOGMA_HW_PRODUCT_ID R
Hardware Product Id
SW_PRODUCT_ID number 22  √  null
BDNA_SW_PRODUCT_INFO.SW_PRODUCT_ID BDNAINVCATALOGMA_SW_PRODUCT_ID R
Software Product Id
CPU_ID number 22  √  null
BDNA_HW_CPU_INFO.HW_CPU_ID BDNA_INV_CATALOG_MAP3_CPU_ID R
Hardware CPU Id
INVENTORY_ID number 22 -1
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNA_ALL_OS R
BDNA_DB2_FEATURES.INVENTORY_ID FKM1_BDNADB2FEATURES R
BDNA_DB2_INSTALLS.INVENTORY_ID FKM1_BDNADB2INSTALLS R
BDNA_DB2_INSTANCES.INVENTORY_ID FKM1_BDNADB2INSTANCE R
BDNA_DB2_LICMLIST.INVENTORY_ID FKM0_BDNADB2LICMLIST R
BDNA_FP_APPS.INVENTORY_ID FKM1_BDNA_FP_APPS R
BDNA_GUARDIUM_MODULES.INVENTORY_ID FKM0_BDNAGUARDIUMMOD R
BDNA_IFMX_INSTALLS.INVENTORY_ID FKM1_BDNAIFMXINSTALL R
BDNA_IFMX_INSTANCES.INVENTORY_ID FKM1_BDNAIFMXINSTANC R
BDNA_MSSQL_INSTALLS.INVENTORY_ID FKM1_BDNAMSSQLINSTAL R
BDNA_MSSQL_INSTANCES.INVENTORY_ID FKM1_BDNAMSSQLINSTAN R
BDNA_ORADB_INSTALLS.INVENTORY_ID FKM1_BDNAORADBINSTAL R
BDNA_ORADB_INSTANCES.INVENTORY_ID FKM1_BDNAORADBINSTAN R
BDNA_INVENTORY_INFO.INVENTORY_ID BDNAINVCATALOGMAP_INVENTORY_ID R
Inventory Id

Analyzed at Fri Oct 21 21:10 PDT 2016

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA