Table BDNA_PUBLISH.dbo.MATCH_HOST_SW_PROD
Has Matched Host-Software 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
disc_sw_prod_id float 8 Unique Software product id
HOST_ID float 8  √  null
DISC_HOSTS.HOST_ID FK8_MATCH_HOST_SW_PROD R
Host Id for this Software product
HOSTNAME varchar 255  √  null Host name for this Software product
DISCOVERED_NAME varchar 1024  √  null Discovered name for this Software product eg: Adobe Flash Player 9 Plugin,TextPad 4.7
DISCOVERED_VERSION varchar 1024  √  null Discovered version for this Software product eg:9.0.45.0
DISCOVERED_PUBLISHER varchar 1024  √  null Discovered publihser for this Software product eg: Adobe Systems, Inc., Ipswitch
DISCOVERED_INSTALLDATE datetime 16,3  √  null Discovered installed date Software product
cat_publisher varchar 255  √  null Publisher from the catalog for this Software product eg: Adobe Systems, Helios Software Solutions
cat_product_name varchar 255  √  null product name from the catalog for this Software product eg: Flash Player, Photoshop Camera Raw
cat_product_family varchar 255  √  null product family from the catalog for this Software product eg: Office, Acrobat
cat_component varchar 64  √  null product component from the catalog for this Software product eg: Client, Server
cat_patchlevel varchar 64  √  null Patch level from the catalog for this Software product eg: SP2
cat_version varchar 64  √  null version from the catalog for this Software product eg: 2007, 2.0
cat_version_group varchar 64  √  null version group from the catalog for this Software product eg: CS3, 2007
cat_edition varchar 2000  √  null edition from the catalog for this Software product eg: Design Standard, Professional
cat_taxonomy_category1 varchar 256  √  null taxonomy category 1 from the catalog for this Software product eg: Applications, Utilities
cat_taxonomy_category2 varchar 256  √  null taxonomy category 2 from the catalog for this Software product eg: Productivity, Multimedia
IS_SUITE char 1  √  null Catalog information: if this software product part of suite? eg: N, Y
cat_licensable varchar 16  √  null Catalog information: if this software product licensable? eg: yes, no
cat_licensable_detail varchar 50  √  null Catalog information: if this software product licensable? eg: yes, no,Generally Licensable, Some Releases are Licensable
cat_ga_date varchar 60  √  null GA date from catalog for this Software product
cat_publisher_id float 8  √  null publisher Id from catalog for this Software product
cat_product_id float 8  √  null product Id from catalog for this Software product
cat_version_id float 8  √  null version Id from catalog for this Software product
cat_release_id float 8  √  null release Id from catalog for this Software product
cat_edition_id float 8  √  null edition Id from catalog for this Software product
cat_taxonomy_id float 8  √  null taxonomy Id from catalog for this Software product
SUITE_ID float 8  √  null suite Id from catalog for this Software product
GROUP_ID float 8  √  null group Id from catalog for this Software product
TASK_ID float 8  √  null
DISC_HOSTS.TASK_ID FK8_MATCH_HOST_SW_PROD R
MATCH_TASK_DET.TASK_ID FK6_MATCH_HOST_SW_PROD R
Task Id for this row
INVENTORY_ID float 8  √  null
DISC_HOSTS.INVENTORY_ID FK8_MATCH_HOST_SW_PROD R
MATCH_INVENTORY.INVENTORY_ID FK7_MATCH_HOST_SW_PROD R
Inventory Id for this row
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
disc_sw_prod_id Primary key Asc PK_MATCH_HOST_SW_PROD
cat_taxonomy_category2 + cat_taxonomy_category1 + HOST_ID Performance Asc/Asc/Asc REP_IDX__dta_index_MATCH_HOST_SW_PROD_8_645577338__K14_K13_K2_18_19_20_21_22
cat_taxonomy_category2 + INVENTORY_ID + cat_taxonomy_category1 Performance Asc/Asc/Asc REP_IDX__dta_index_MATCH_HOST_SW_PROD_8_645577338__K14_K27_K13_7_8_10_12
cat_release_id Performance Asc REP_IDX__dta_index_MATCH_HOST_SW_PROD_8_645577338__K21_1_2_3_4_5_6_7_8_9_10_11_12_13_14_15_16_17_18_19_20_22_23_24_25_26_27_28
cat_release_id + INVENTORY_ID + SUITE_ID + HOST_ID Performance Asc/Asc/Asc/Asc REP_IDX__dta_index_MATCH_HOST_SW_PROD_8_645577338__K21_K27_K24_K2
cat_taxonomy_id + INVENTORY_ID + cat_publisher_id Performance Asc/Asc/Asc REP_IDX__dta_index_MATCH_HOST_SW_PROD_8_645577338__K23_K27_K18
SUITE_ID + INVENTORY_ID Performance Asc/Asc REP_IDX__dta_index_MATCH_HOST_SW_PROD_8_645577338__K24_K27_7_8_10_11_12_16
SUITE_ID + INVENTORY_ID Performance Asc/Asc REP_IDX__dta_index_MATCH_HOST_SW_PROD_8_645577338__K24_K27_7_8_9_10_11_12_16
SUITE_ID + INVENTORY_ID Performance Asc/Asc REP_IDX__dta_index_MATCH_HOST_SW_PROD_8_645577338__K24_K27_7_8_9_16
SUITE_ID + INVENTORY_ID Performance Asc/Asc REP_IDX__dta_index_MATCH_HOST_SW_PROD_8_645577338__K24_K27_8_10_11_12
INVENTORY_ID Performance Asc REP_IDX__dta_index_MATCH_HOST_SW_PROD_8_645577338__K27_7_16_24
INVENTORY_ID Performance Asc REP_IDX__dta_index_MATCH_HOST_SW_PROD_8_645577338__K27_7_24
INVENTORY_ID + cat_taxonomy_category2 + cat_taxonomy_category1 Performance Asc/Asc/Asc REP_IDX__dta_index_MATCH_HOST_SW_PROD_8_645577338__K27_K14_K13_7
INVENTORY_ID + cat_taxonomy_category2 + cat_taxonomy_category1 + HOST_ID Performance Asc/Asc/Asc/Asc REP_IDX__dta_index_MATCH_HOST_SW_PROD_8_645577338__K27_K14_K13_K2
INVENTORY_ID + cat_taxonomy_id + HOST_ID Performance Asc/Asc/Asc REP_IDX__dta_index_MATCH_HOST_SW_PROD_8_645577338__K27_K23_K2
INVENTORY_ID + SUITE_ID Performance Asc/Asc REP_IDX__dta_index_MATCH_HOST_SW_PROD_8_645577338__K27_K24_8_9
INVENTORY_ID + HOST_ID + cat_release_id Performance Asc/Asc/Asc REP_IDX__dta_index_MATCH_HOST_SW_PROD_8_645577338__K27_K2_K21_16
cat_publisher_id + cat_product_id + cat_version_id + cat_edition_id + cat_release_id Performance Asc/Asc/Asc/Asc/Asc REP_IDX__dta_index_MATCH_HOST_SW_PROD_c_8_645577338__K18_K19_K20_K22_K21
INVENTORY_ID + HOST_ID + cat_release_id + cat_licensable + SUITE_ID + IS_SUITE + cat_taxonomy_id Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc REP_IDX_IDX_MHSWP_1

Close relationships  within of separation: