Table BDNA_PUBLISH.dbo.CAT_HARDWARE_PRODUCT
Hardware 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_MODEL.HW_PRODUCT_ID FK2_CAT_HARDWARE_MODEL R
CAT_HW_MODEL_PROFILE.HW_PRODUCT_ID FK2_CAT_HW_MODEL_PROFILE R
CAT_HARDWARE_PRODUCT table's unique identifier
LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
LABEL varchar 255  √  null Hardware product name
MANUFACTURER_ID float 8  √  null
CAT_MANUFACTURER.ID FK0_CAT_HARDWARE_PRODUCT R
Manufacturer's unique identifier
TAXONOMY_ID float 8  √  null
CAT_TAXONOMY.ID FK1_CAT_HARDWARE_PRODUCT R
BDNA Taxonomy's unique identifier

Analyzed at Thu Oct 04 14:29 PDT 2012

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

Close relationships  within of separation: