Table BDNA_PUBLISH.dbo.CAT_SOFTWARE_VERSION
Software Version table with patch level info

 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_RELEASE.VERSION_ID FK4_CAT_SOFTWARE_RELEASE R
CAT_SOFTWARE_VERSION table's unique identifier
LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
PRODUCT_ID float 8  √  null
CAT_SOFTWARE.ID FK0_CAT_SW_VERSION R
Software product's unique identifier
VERSION_GROUP_ID float 8  √  null
CAT_SW_VERSION_GROUP.ID FK1_CAT_SW_VERSION R
Software version group's unique identifier
LABEL varchar 64  √  null Software patch's name/number
PATCHLEVEL varchar 64  √  null Software Subversion (BDNA Internal column)
SUBVERSION varchar 60  √  null Software patch's level (Critical or Optional)

Analyzed at Thu Oct 04 14:29 PDT 2012

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

Close relationships  within of separation: