Table BDNA_PUBLISH.dbo.DISC_CS_CAT_MAP
Has Discovered Computer system to Catalog Mappping information

 Generated by
SchemaSpy
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 float 8
DISC_COMPUTERSYSTEM.COMPUTERSYSTEM_ID FK0_DISC_CS_CAT_MAP R
Computer System Id for this computer
INVENTORY_ID float 8
DISC_COMPUTERSYSTEM.INVENTORY_ID FK0_DISC_CS_CAT_MAP R
MATCH_INVENTORY.INVENTORY_ID FK2_DISC_CS_CAT_MAP R
Inventory Id for this row
TASK_ID float 8
DISC_COMPUTERSYSTEM.TASK_ID FK0_DISC_CS_CAT_MAP R
MATCH_TASK_DET.TASK_ID FK1_DISC_CS_CAT_MAP R
Task Id for this row
CAT_MANUFACTURER_ID float 8  √  null Manufacturer Id from the catalog
CAT_HW_PRODUCT_ID float 8  √  null Hardware Product Id from the catalog
CAT_HW_MODEL_ID float 8  √  null Hardware model Id from the catalog
CAT_HW_PROFILE_ID float 8  √  null Hardware profile Id from the catalog
CAT_TAXONOMY_ID float 8  √  null Taxonomy Id from the catalog
DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
VIRTUAL float 8  √  null Is this hardware virtual?

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
COMPUTERSYSTEM_ID + TASK_ID + INVENTORY_ID Primary key Asc/Asc/Asc PK_DISC_CS_CAT_MAP
INVENTORY_ID Performance Asc REP_IDX__dta_index_DISC_CS_CAT_MAP_8_981578535__K2_5
INVENTORY_ID + CAT_HW_MODEL_ID Performance Asc/Asc REP_IDX__dta_index_DISC_CS_CAT_MAP_8_981578535__K2_K6

Close relationships  within of separation: