Table BDNA_PUBLISH.dbo.CAT_SOFTWARE
Software 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_SOFTWARE_EDITION.PRODUCT_ID FK0_CAT_SW_EDITION R
CAT_SOFTWARE_RELEASE.PRODUCT_ID FK1_CAT_SOFTWARE_RELEASE R
CAT_SOFTWARE_VERSION.PRODUCT_ID FK0_CAT_SW_VERSION R
CAT_SW_VERSION_GROUP.PRODUCT_ID FK0_CAT_SW_VERSION_GROUP R
CAT_SOFTWARE 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_SOFTWARE R
Manufacturer's unique identifier
LABEL varchar 2000  √  null The name of the software product
FAMILY varchar 255  √  null Brand/family in which the software product belongs to (if applicable)
COMPONENT varchar 64  √  null The component of the software product (if applicable)
TAXONOMY_ID float 8  √  null
CAT_TAXONOMY.ID FK1_CAT_SOFTWARE R
BDNA Taxonomy's unique identifier
ALIAS varchar 255  √  null Former/older name the software product was also known as
SUITE float 8  √  null A flag to indicate whether the software product is a suite or not
PLICSABLE float 8  √  null A flag to indicate whether the software product is licensable or not

Analyzed at Thu Oct 04 14:29 PDT 2012

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

Close relationships  within of separation: