Table BDNA_PUBLISH.dbo.CAT_HW_MODEL_PROFILE
Hardware model profile 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_HW_MODEL_PROFILE 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_HW_MODEL_PROFILE R
Manufacturer's unique identifier
HW_PRODUCT_ID float 8  √  null
CAT_HARDWARE_PRODUCT.ID FK2_CAT_HW_MODEL_PROFILE R
Hardware product's unique identifier
HW_MODEL_ID float 8  √  null
CAT_HARDWARE_MODEL.ID FK3_CAT_HW_MODEL_PROFILE R
Hardware model's unique identifier
TAXONOMY_ID float 8  √  null
CAT_TAXONOMY.ID FK1_CAT_HW_MODEL_PROFILE R
BDNA Taxonomy's unique identifier
PROFILE varchar 60  √  null Profile (or form factor) of the device
MIN_HEIGHT float 8  √  null Minimum height of the device (in inches)
MIN_WIDTH float 8  √  null Minimum width of the device (in inches)
MIN_DEPTH float 8  √  null Minimum depth of the device (in inches)
MIN_WEIGHT float 8  √  null Minimum weight of the device (in lbs)
MAX_HEIGHT float 8  √  null Maximum height of the device (in inches)
MAX_WIDTH float 8  √  null Maximum width of the device (in inches)
MAX_DEPTH float 8  √  null Maximum depth of the device (in inches)
MAX_WEIGHT float 8  √  null Maximum weight of the device (in lbs)

Analyzed at Thu Oct 04 14:29 PDT 2012

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

Close relationships  within of separation: