Table BDNA_PUBLISH.dbo.DISC_OS_CAT_MAP
Has Discovered Operating 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
OPERATINGSYSTEM_ID float 8 Operating System Id for the opearting sytem
INVENTORY_ID float 8
MATCH_INVENTORY.INVENTORY_ID FK1_DISC_OS_CAT_MAP R
Inventory Id for this row
TASK_ID float 8
MATCH_TASK_DET.TASK_ID FK0_DISC_OS_CAT_MAP R
Task Id for this row
CAT_MANUFACTURER_ID float 8  √  null Manufactuer id from Catalog
CAT_SW_PRODUCT_ID float 8  √  null Software product Id from Catalog
CAT_SW_VERSION_ID float 8  √  null software version Id from Catalog
CAT_SW_EDITION_ID float 8  √  null software edition Id from Catalog
CAT_SW_RELEASE_ID float 8  √  null software release Id from Catalog
CAT_TAXONOMY_ID float 8  √  null software taxonomy Id from Catalog
DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
OPERATINGSYSTEM_ID + TASK_ID + INVENTORY_ID Primary key Asc/Asc/Asc PK_DISC_OS_CAT_MAP
INVENTORY_ID + CAT_SW_RELEASE_ID Performance Asc/Asc REP_IDX__dta_index_DISC_OS_CAT_MAP_8_1141579105__K2_K8

Close relationships  within of separation: