Table BDNA_PUBLISH.dbo.MATCH_HOST_HW_PROD_MODEL
Has Matched Host-Hardware Model 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
INVENTORY_ID float 8
MATCH_INVENTORY.INVENTORY_ID FK0_MATCH_HOST_HW_PROD_MODEL R
Inventory Id for this row
TASK_ID float 8
MATCH_TASK_DET.TASK_ID FK1_MATCH_HOST_HW_PROD_MODEL R
Task Id for this row
DISCOVERED_DOMAIN nvarchar 2048  √  null Domain name
DISCOVERED_MANUFACTURER nvarchar 2048  √  null Product manufacturer eg: Compaq
DISCOVERED_MODEL nvarchar 2048  √  null Model for this hardware product eg: Latitude D610
DISCOVERED_HOSTNAME nvarchar 2048  √  null Hostname for this hardware product
DISCOVERED_DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
DISCOVERED_HOST_ID float 8 Host Id for this hardware product
DISCOVERED_SERIALNUMBER nvarchar 512  √  null serialnumber for this hardware product
CAT_HW_PRODUCT_ID float 8  √  null catalog product Id for this hardware product
CAT_HARDWARE_PRODUCT nvarchar 510  √  null catalog Hostname for this hardware product
CAT_MANUFACTURER_ID float 8  √  null catalog manufacturer Id for this hardware product
CAT_MANUFACTURER nvarchar 4000  √  null catalog manufacturer name for this hardware product eg: Hewlett-Packard Company
CAT_HARDWARE_MODEL_ID float 8 catalog manufacturer model id for this hardware product
CAT_HARDWARE_MODEL nvarchar 4000  √  null catalog manufacturer model for this hardware product eg: 397307-xx1
CAT_SUPPORTED_OS nvarchar 4000  √  null catalog supported OS for this hardware product eg: Linux, NetWare, OpenServer, Solaris, UnixWare, Windows, VMware
CAT_DATE_INTRODUCED nvarchar 60  √  null date introduced from the catalog
CAT_DATE_AVAILABLE nvarchar 60  √  null date available from the catalog
CAT_END_OF_LIFE_DATE nvarchar 60  √  null end of life date from the catalog
CAT_END_OF_SALES_DATE nvarchar 60  √  null end of sales date from the catalog
CAT_LAST_SHIP_DATE nvarchar 60  √  null last ship date date from the catalog
CAT_LAST_SUPPORT_DATE nvarchar 60  √  null last support date date from the catalog
CAT_ENERGY_STAR nvarchar 6  √  null energy star from the catalog eg: yes, no
CAT_EPEAT nvarchar 40  √  null EPEAT star from the catalog eg: Gold, Silver
CAT_AC_POWER_AVG nvarchar 120  √  null AC power average from the catalog
CAT_AC_AVG_UNIT nvarchar 16  √  null AC average unit from the catalog eg: watt
CAT_AC_POWER_MAX nvarchar 120  √  null AC power max from the catalog
CAT_AC_MAX_UNIT nvarchar 16  √  null AC power max unit from the catalog eg: watt
CAT_DC_POWER_AVG nvarchar 120  √  null DC power average from the catalog
CAT_DC_POWER_MAX nvarchar 120  √  null DC power max from the catalog
CAT_AC_HEAT_DISS_AVG nvarchar 120  √  null AC average heat dissipation from the catalog
CAT_AC_HEAT_DISS_MAX nvarchar 120  √  null AC max heat dissipation from the catalog
CAT_DC_HEAT_DISS_AVG nvarchar 120  √  null DC average heat dissipation from the catalog
CAT_DC_HEAT_DISS_MAX nvarchar 120  √  null DC max heat dissipation from the catalog
CAT_MIN_OPERATING_TEMP float 8  √  null Minimum operating temparature from the catalog
CAT_MAX_OPERATING_TEMP float 8  √  null Maximum operating temparature from the catalog
CAT_MIN_NON_OPERATING_TEMP float 8  √  null Minimum non operating temparature from the catalog
CAT_MAX_NON_OPERATING_TEMP float 8  √  null Maximum non operating temparature from the catalog
CAT_MIN_OPERATING_HUMIDITY float 8  √  null Minimum operating humidity from the catalog
CAT_MAX_OPERATING_HUMIDITY float 8  √  null Maximum operating humidity from the catalog
CAT_MIN_NON_OPERATING_HUMIDITY float 8  √  null Minimum non operating humidity from the catalog
CAT_MAX_NON_OPERATING_HUMIDITY float 8  √  null Maximum non operating humidity from the catalog
CAT_POWER_RATING nvarchar 512  √  null Power rating from the catalog eg: 100-132/200-240 VAC, 50-60 Hz, 10-6.1 A
CAT_AC_INPUT_LOW_VOLT_MIN float 8  √  null AC minimum low volatage from the catalog
CAT_AC_INPUT_LOW_VOLT_MAX float 8  √  null AC maximum low volatage from the catalog
CAT_AC_INPUT_LOW_CURRENT_MIN float 8  √  null AC minimum low current from the catalog
CAT_AC_INPUT_LOW_CURRENT_MAX float 8  √  null AC maximum low current from the catalog
CAT_AC_INPUT_HIGH_VOLT_MIN float 8  √  null AC minimum high volatage from the catalog
CAT_AC_INPUT_HIGH_VOLT_MAX float 8  √  null AC maximum high volatage from the catalog
CAT_AC_INPUT_HIGH_CURRENT_MIN float 8  √  null AC minimum high current from the catalog
CAT_AC_INPUT_HIGH_CURRENT_MAX float 8  √  null AC maximum high current from the catalog
CAT_AC_FREQ_MIN float 8  √  null AC minumum frequency from the catalog
CAT_AC_FREQ_MAX float 8  √  null AC maximum frequency from the catalog
CAT_DC_LOW_VOLT float 8  √  null DC low voltage from the catalog
CAT_DC_LOW_CURRENT float 8  √  null DC low current from the catalog
CAT_DC_HIGH_VOLT float 8  √  null DC high voltage from the catalog
CAT_DC_HIGH_CURRENT float 8  √  null DC high current from the catalog
CAT_TAXONOMY_CATEGORY1 nvarchar 512  √  null Taxonomy category 1 from the catalog eg: Computers
CAT_TAXONOMY_CATEGORY2 nvarchar 512  √  null Taxonomy category 2 from the catalog eg: Computers eg: Servers ,Desktops, Notebooks

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
DISCOVERED_HOST_ID + CAT_HARDWARE_MODEL_ID + INVENTORY_ID + TASK_ID Primary key Asc/Asc/Asc/Asc PK_MATCH_HOST_HW_PROD_MODEL

Close relationships  within of separation: