Table BDNA_PUBLISH.dbo.CAT_HARDWARE_MODEL
Hardware model information table

 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
ID float 8
CAT_HARDWARE_LIFECYCLE.MODEL_ID FK0_CAT_HARDWARE_LIFECYCLE R
CAT_HW_MODEL_PROFILE.HW_MODEL_ID FK3_CAT_HW_MODEL_PROFILE R
CAT_HARDWARE_MODEL table's unique identifier
LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
MANUFACTURER_ID float 8  √  null
CAT_MANUFACTURER.ID FK0_CAT_HARDWARE_MODEL R
Manufacturer's unique identifier
HW_PRODUCT_ID float 8  √  null
CAT_HARDWARE_PRODUCT.ID FK2_CAT_HARDWARE_MODEL R
Hardware product's unique identifier
TAXONOMY_ID float 8  √  null
CAT_TAXONOMY.ID FK1_CAT_HARDWARE_MODEL R
BDNA Taxonomy's unique identifier
LABEL varchar 2000  √  null The device's model name/number
SUPPORTED_OS varchar 2000  √  null The list of supported operating systems that can be run on the device
DATE_INTRODUCED varchar 30  √  null The date the hardware was introduced/announced, captured the way it was published by the vendor
DATE_AVAILABLE varchar 30  √  null The date the hardware was available for sale, captured the way it was published by the vendor
END_OF_LIFE_DATE varchar 30  √  null The date where a device is announced to ?iscontinued?or ?egacy?by the manufacturer
END_OF_SALES_DATE varchar 30  √  null The last date to order the product through manufacturer point-of-sale mechanisms.
LAST_SHIP_DATE varchar 30  √  null The last-possible ship date that can be requested of the manufacturer and/or its contract manufacturers
LAST_SUPPORT_DATE varchar 30  √  null The last date the support will be provided by the manufacturer (even after the device has been discontinued). After this date, all support services for the product are unavailable, and the product becomes obsolete.
ENERGY_STAR varchar 3  √  null A flag to indicate whether the device has earned the Energy Star certification or not
EPEAT varchar 20  √  null A flag to indicate which EPEAT certification the device has earned: Gold, Silver, or Bronze
AC_POWER_AVG varchar 60  √  null The average amount of power (energy per-unit of time) consumed by the device during typical use when it is hooked up to AC power (in watt or volt-amp)
AC_AVG_UNIT varchar 8  √  null The unit for AC_POWER_AVG column (watt or volt-amp)
AC_POWER_MAX varchar 60  √  null The peak/maximum amount of power (energy per-unit of time) consumed by the device when it is hooked up to AC power (in watt or volt-amp)
AC_MAX_UNIT varchar 8  √  null The unit for AC_POWER_MAX column (watt or volt-amp)
DC_POWER_AVG varchar 60  √  null The average amount of power (energy per-unit of time) consumed by the device during typical use when it is hooked up to DC power (in watt or volt-amp)
DC_POWER_MAX varchar 60  √  null The peak/maximum amount of power (energy per-unit of time) consumed by the device when it is hooked up to DC power (in watt or volt-amp)
AC_HEAT_DISS_AVG varchar 60  √  null The average amount of heat per-unit of time generated by the device during typical use when it is hooked up to AC power (in BTU/hr)
AC_HEAT_DISS_MAX varchar 60  √  null The peak/maximum amount of heat per-unit of time generated by the device when it is hooked up to AC power (in BTU/hr)
DC_HEAT_DISS_AVG varchar 60  √  null The average amount of heat per-unit of time generated by the device during typical use when it is hooked up to DC power (in BTU/hr)
DC_HEAT_DISS_MAX varchar 60  √  null The peak/maximum amount of heat per-unit of time generated by the device when it is hooked up to DC power (in BTU/hr)
MIN_OPERATING_TEMP float 8  √  null Manufacturer's suggested minimum temperature of the device during operation (in ?)
MAX_OPERATING_TEMP float 8  √  null Manufacturer's suggested peak/maximum temperature of the device during operation (in ?)
MIN_NON_OPERATING_TEMP float 8  √  null Manufacturer's suggested minimum temperature of the device when it is non-operational or in storage (in ?)
MAX_NON_OPERATING_TEMP float 8  √  null Manufacturer's suggested peak/maximum temperature of the device when it is non-operational or in storage (in ?)
MIN_OPERATING_HUMIDITY float 8  √  null Manufacturer's suggested minimum humidity of the device during operation (in %)
MAX_OPERATING_HUMIDITY float 8  √  null Manufacturer's suggested peak/maximum humidity of the device during operation (in %)
MIN_NON_OPERATING_HUMIDITY float 8  √  null Manufacturer's suggested minimum humidity of the device when it is non-operational or in storage (in %)
MAX_NON_OPERATING_HUMIDITY float 8  √  null Manufacturer's suggested peak/maximum humidity of the device when it is non-operational or in storage (%)
POWER_RATING varchar 256  √  null Summary of the device's various power ratings: Voltage, Frequency, Current
AC_INPUT_LOW_VOLT_MIN float 8  √  null Manufacturer's suggested AC electrical input requirements: minimum voltage when the voltage switch is turned on the low range setting, or when the device has no voltage switch (single voltage range)
AC_INPUT_LOW_VOLT_MAX float 8  √  null Manufacturer's suggested AC electrical input requirements: maximum voltage when the voltage switch is turned on the low range setting, or when the device has no voltage switch (single voltage range)
AC_INPUT_LOW_CURRENT_MIN float 8  √  null Manufacturer's suggested AC electrical input requirements: minimum current when the voltage switch is turned on the low range setting, or when the device has no voltage switch (single voltage range)
AC_INPUT_LOW_CURRENT_MAX float 8  √  null Manufacturer's suggested AC electrical input requirements: maximum current when the voltage switch is turned on the low range setting, or when the device has no voltage switch (single voltage range)
AC_INPUT_HIGH_VOLT_MIN float 8  √  null Manufacturer's suggested AC electrical input requirements: minimum voltage when the voltage switch is turned on the high range setting
AC_INPUT_HIGH_VOLT_MAX float 8  √  null Manufacturer's suggested AC electrical input requirements: maximum voltage when the voltage switch is turned on the high range setting
AC_INPUT_HIGH_CURRENT_MIN float 8  √  null Manufacturer's suggested AC electrical input requirements: minimum current when the voltage switch is turned on the high range setting
AC_INPUT_HIGH_CURRENT_MAX float 8  √  null Manufacturer's suggested AC electrical input requirements: maximum current when the voltage switch is turned on the high range setting
AC_FREQ_MIN float 8  √  null Manufacturer's suggested AC input requirements: minimum frequency (whether the voltage switch is turned on low/high or when the device has no voltage switch)
AC_FREQ_MAX float 8  √  null Manufacturer's suggested AC input requirements: maximum frequency (whether the voltage switch is turned on low/high or when the device has no voltage switch)
DC_LOW_VOLT float 8  √  null Manufacturer's suggested DC input requirements: voltage when the voltage switch is turned on the low setting or when the device has no voltage switch (single voltage)
DC_LOW_CURRENT float 8  √  null Manufacturer's suggested DC input requirements: current when the voltage switch is turned on the low setting or when the device has no voltage switch (single voltage)
DC_HIGH_VOLT float 8  √  null Manufacturer's suggested DC input requirements: voltage when the voltage switch is turned on the high setting
DC_HIGH_CURRENT float 8  √  null Manufacturer's suggested DC input requirements: current when the voltage switch is turned on the high setting

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc PK_CAT_HARDWARE_MODEL

Close relationships  within of separation: