BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_HOST_HW_PROD_MODEL - Host-Hardware Model information matched

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 number 18  √  null
MATCH_INVENTORY.INVENTORY_ID FK0_MATCH_HOST_HW_PROD_MODEL R
Inventory ID for this row
TASK_ID number 18  √  null
MATCH_TASK_DET.TASK_ID FK1_MATCH_HOST_HW_PROD_MODEL R
Task ID for this row
DISCOVERED_DOMAIN nvarchar2 1024  √  null Domain name
DISCOVERED_MANUFACTURER nvarchar2 1024  √  null Product manufacturer (e.g., Compaq)
DISCOVERED_MODEL nvarchar2 1024  √  null Model for this hardware product (e.g., Latitude D610)
DISCOVERED_HOSTNAME nvarchar2 1024  √  null Hostname for this hardware product
DISCOVERED_DATASRC nvarchar2 25  √  null Data Source for this row (e.g., SCCM, ADDM)
DISCOVERED_HOST_ID number 0  √  null Host ID for this hardware product
DISCOVERED_SERIALNUMBER nvarchar2 256  √  null Serial number for this hardware product
CAT_HW_PRODUCT_ID number 18  √  null Catalog product ID for this hardware product
CAT_HARDWARE_PRODUCT varchar2 255  √  null Catalog hostname for this hardware product
CAT_MANUFACTURER_ID number 18  √  null Catalog manufacturer ID for this hardware product
CAT_MANUFACTURER varchar2 2000  √  null Catalog manufacturer name for this hardware product (e.g., Hewlett-Packard Company)
CAT_HW_MODEL_ID number 18  √  null catalog manufacturer model ID for this hardware product
CAT_HW_MODEL varchar2 2000  √  null Catalog manufacturer model for this hardware product (e.g., 397307-xx1)
CAT_CPE_URI_ID number 18  √  null
CAT_SUPPORTED_OS varchar2 2000  √  null Catalog supported OS for this hardware product (e.g., Linux, NetWare, OpenServer, Solaris, UnixWare, Windows, Vmware)
CAT_DATE_INTRODUCED varchar2 30  √  null Date introduced from the catalog
CAT_DATE_AVAILABLE varchar2 30  √  null Date available from the catalog
CAT_END_OF_LIFE_DATE varchar2 30  √  null End-of-life date from the catalog
CAT_END_OF_SALES_DATE varchar2 30  √  null End-of-sales date from the catalog
CAT_LAST_SHIP_DATE varchar2 30  √  null Last ship date date from the catalog
CAT_LAST_SUPPORT_DATE varchar2 30  √  null Last support date date from the catalog
CAT_ENERGY_STAR varchar2 3  √  null Energy star from the catalog (e.g., yes, no)
CAT_EPEAT varchar2 20  √  null EPEAT star from the catalog (e.g., Gold, Silver)
CAT_AC_POWER_AVG varchar2 60  √  null AC power average from the catalog
CAT_AC_AVG_UNIT varchar2 8  √  null AC average unit from the catalog (e.g., watt)
CAT_AC_POWER_MAX varchar2 60  √  null AC power max from the catalog
CAT_AC_MAX_UNIT varchar2 8  √  null AC power max unit from the catalog (e.g., watt)
CAT_DC_POWER_AVG varchar2 60  √  null DC power average from the catalog
CAT_DC_POWER_MAX varchar2 60  √  null DC power max from the catalog
CAT_AC_HEAT_DISS_AVG varchar2 60  √  null AC average heat dissipation from the catalog
CAT_AC_HEAT_DISS_MAX varchar2 60  √  null AC max heat dissipation from the catalog
CAT_DC_HEAT_DISS_AVG varchar2 60  √  null DC average heat dissipation from the catalog
CAT_DC_HEAT_DISS_MAX varchar2 60  √  null DC max heat dissipation from the catalog
CAT_MIN_OPERATING_TEMP float 126  √  null Minimum operating temparature from the catalog
CAT_MAX_OPERATING_TEMP float 126  √  null Maximum operating temparature from the catalog
CAT_MIN_NON_OPERATING_TEMP float 126  √  null Minimum non-operating temparature from the catalog
CAT_MAX_NON_OPERATING_TEMP float 126  √  null Maximum non-operating temparature from the catalog
CAT_MIN_OPERATING_HUMIDITY float 126  √  null Minimum operating humidity from the catalog
CAT_MAX_OPERATING_HUMIDITY float 126  √  null Maximum operating humidity from the catalog
CAT_MIN_NON_OPERATING_HUMIDITY float 126  √  null Minimum non-operating humidity from the catalog
CAT_MAX_NON_OPERATING_HUMIDITY float 126  √  null Maximum non-operating humidity from the catalog
CAT_POWER_RATING varchar2 256  √  null Power rating from the catalog (e.g., 100-132/200-240 VAC, 50-60 Hz, 10-6.1 A)
CAT_AC_INPUT_LOW_VOLT_MIN float 126  √  null AC minimum low voltage from the catalog
CAT_AC_INPUT_LOW_VOLT_MAX float 126  √  null AC maximum low voltage from the catalog
CAT_AC_INPUT_LOW_CURRENT_MIN float 126  √  null AC minimum low current from the catalog
CAT_AC_INPUT_LOW_CURRENT_MAX float 126  √  null AC maximum low current from the catalog
CAT_AC_INPUT_HIGH_VOLT_MIN float 126  √  null AC minimum high voltage from the catalog
CAT_AC_INPUT_HIGH_VOLT_MAX float 126  √  null AC maximum high voltage from the catalog
CAT_AC_INPUT_HIGH_CURRENT_MIN float 126  √  null AC minimum high current from the catalog
CAT_AC_INPUT_HIGH_CURRENT_MAX float 126  √  null AC maximum high current from the catalog
CAT_AC_FREQ_MIN float 126  √  null AC minimum frequency from the catalog
CAT_AC_FREQ_MAX float 126  √  null AC maximum frequency from the catalog
CAT_DC_LOW_VOLT float 126  √  null DC low voltage from the catalog
CAT_DC_LOW_CURRENT float 126  √  null DC low current from the catalog
CAT_DC_HIGH_VOLT float 126  √  null DC high voltage from the catalog
CAT_DC_HIGH_CURRENT float 126  √  null DC high current from the catalog
CAT_TAXONOMY_CATEGORY1 varchar2 256  √  null Taxonomy category 1 from the catalog (e.g., Computers)
CAT_TAXONOMY_CATEGORY2 varchar2 256  √  null Taxonomy category 2 from the catalog (e.g., Computers: Servers, Desktops, Notebooks)
PHYSICALHOST number 0  √  null Physical Host?
PHYSICALHOST_ID number 0  √  null Physical Host Id
VIRTUAL number 0  √  null Is this hardware virtual?

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
INVENTORY_ID + TASK_ID + DISCOVERED_HOST_ID + CAT_HW_PRODUCT_ID + CAT_HW_MODEL_ID Performance Asc/Asc/Asc/Asc/Asc MATCH_HSW_PRD_HID_IDX

Close relationships  within of separation:
Confidential and Proprietary to BDNA