Table BDNA_PUBLISH.dbo.CAT_TAXONOMY
Taxonomy 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.TAXONOMY_ID FK1_CAT_HARDWARE_MODEL R
CAT_HARDWARE_PRODUCT.TAXONOMY_ID FK1_CAT_HARDWARE_PRODUCT R
CAT_HW_MODEL_PROFILE.TAXONOMY_ID FK1_CAT_HW_MODEL_PROFILE R
CAT_SOFTWARE.TAXONOMY_ID FK1_CAT_SOFTWARE R
CAT_SOFTWARE_EDITION.TAXONOMY_ID FK1_CAT_SW_EDITION R
Category 2 ID
PARENT_ID float 8  √  null Category 1 ID
LABEL varchar 256  √  null Category 2 name
DESCRIPTION varchar 256  √  null Short description of the category
LABEL_IN_FRENCH varchar 256  √  null
LABEL_IN_GERMAN varchar 256  √  null

Analyzed at Thu Oct 04 14:29 PDT 2012

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

Close relationships  within of separation: