BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_CS_CAT_MAP - Computer 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
COMPUTERSYSTEM_ID number 0  √  null
DISC_COMPUTERSYSTEM.COMPUTERSYSTEM_ID FK0_DISC_CS_CAT_MAP R
Computer System ID for this computer
INVENTORY_ID number 18  √  null
MATCH_INVENTORY.INVENTORY_ID FK2_DISC_CS_CAT_MAP R
DISC_COMPUTERSYSTEM.INVENTORY_ID FK0_DISC_CS_CAT_MAP R
Inventory ID for this row
TASK_ID number 18  √  null
MATCH_TASK_DET.TASK_ID FK1_DISC_CS_CAT_MAP R
DISC_COMPUTERSYSTEM.TASK_ID FK0_DISC_CS_CAT_MAP R
Task ID for this row
CAT_MANUFACTURER_ID number 18  √  null Manufacturer ID from the catalog
CAT_HW_PRODUCT_ID number 18  √  null Hardware Product ID from the catalog
CAT_HW_MODEL_ID number 18  √  null Hardware model ID from the catalog
CAT_HW_MODEL_PROFILE_ID number 18  √  null Hardware profile ID from the catalog
CAT_TAXONOMY2012_ID number 18  √  null Taxonomy ID from the catalog
CAT_CPE_URI_ID number 18  √  null CPE URI Id
PHYSICALHOST number 0  √  null Physical Host?
PHYSICALHOST_ID number 0  √  null Physical Host Id
DATASRC varchar2 25  √  null Exceptions column for this row
VIRTUAL number 0  √  null Is this hardware virtual?
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 + COMPUTERSYSTEM_ID Primary key Asc/Asc/Asc PK_DISC_CS_CAT_MAP These unique columns are also nullable
CAT_MANUFACTURER_ID + CAT_HW_PRODUCT_ID + CAT_HW_MODEL_ID + CAT_HW_MODEL_PROFILE_ID + CAT_TAXONOMY2012_ID Performance Asc/Asc/Asc/Asc/Asc DISC_CS_CAT_MAP_IDS_IDX  

Close relationships  within of separation:
Confidential and Proprietary to BDNA