BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_OS_CAT_MAP - Operating System to Catalog Mappping information discovered

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
OPERATINGSYSTEM_ID number 0  √  null Operating System ID for the opearting sytem
INVENTORY_ID number 18  √  null
MATCH_INVENTORY.INVENTORY_ID FK1_DISC_OS_CAT_MAP R
Inventory ID for this row
TASK_ID number 18  √  null
MATCH_TASK_DET.TASK_ID FK0_DISC_OS_CAT_MAP R
Task ID for this row
CAT_MANUFACTURER_ID number 18  √  null Manufactuer ID from Catalog
CAT_SW_PRODUCT_ID number 18  √  null Software product ID from Catalog
CAT_SW_VERSION_ID number 18  √  null Software version ID from Catalog
CAT_SW_EDITION_ID number 18  √  null Software edition ID from Catalog
CAT_SW_RELEASE_ID number 18  √  null Software release ID from Catalog
CAT_TAXONOMY2012_ID number 18  √  null Software taxonomy ID from Catalog
CAT_CPE_URI_ID number 18  √  null CPE URI Id
DATASRC varchar2 25  √  null Data Source for this row (e.g., SCCM, ADDM)
REASONS nvarchar2 1024  √  null Exceptions column for this row

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
INVENTORY_ID + TASK_ID + OPERATINGSYSTEM_ID Primary key Asc/Asc/Asc PK_DISC_OS_CAT_MAP These unique columns are also nullable
CAT_MANUFACTURER_ID + CAT_SW_PRODUCT_ID + CAT_SW_VERSION_ID + CAT_SW_EDITION_ID + CAT_SW_RELEASE_ID + CAT_TAXONOMY2012_ID Performance Asc/Asc/Asc/Asc/Asc/Asc DISC_OS_CAT_MAP_IDS_IDX  

Close relationships  within of separation:
Confidential and Proprietary to BDNA