Table BDNA_PUBLISH.dbo.CAT_SOFTWARE_RELEASE
Software release 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_LIFECYCLE.RELEASE_ID FK0_CAT_SOFTWARE_LIFECYCLE R
CAT_SW_REL_PLATFORM.RELEASE_ID FK0_CAT_SW_REL_PLATFORM R
CAT_SW_REL_SUPP_STAGE.RELEASE_ID FK0_CAT_SW_REL_SUPP_STAGE R
CAT_SOFTWARE_RELEASE 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_RELEASE R
Manufacturer's unique identifier
PRODUCT_ID float 8  √  null
CAT_SOFTWARE.ID FK1_CAT_SOFTWARE_RELEASE R
Software product's unique identifier
LABEL varchar 2000  √  null Software product's unique identifier
EDITION_ID float 8  √  null
CAT_SOFTWARE_EDITION.ID FK2_CAT_SOFTWARE_RELEASE R
Software edition's unique identifier
VERSION_GROUP_ID float 8  √  null
CAT_SW_VERSION_GROUP.ID FK3_CAT_SOFTWARE_RELEASE R
Software version group's unique identifier
VERSION_ID float 8  √  null
CAT_SOFTWARE_VERSION.ID FK4_CAT_SOFTWARE_RELEASE R
Software version's unique identifier
PATCHLEVEL varchar 255  √  null The name of patch level for the software release
GA_DATE_C varchar 60  √  null
GA_DATE varchar 60  √  null The date when the product is generally available through official vendor distributions, captured the way it was published by the vendor
LICENSABLE varchar 16  √  null A flag to indicate whether the software release is licensable or not
WIN732ST float 8  √  null A flag to indicate the compatibilty status of the software release with regards to Windows 7 32-bit. Values: 0-7
WIN732UP varchar 255  √  null The upgrade path for the software release to attain Windows 7 32-bit compatibility
WIN732D varchar 32  √  null The date when the software release attained Windows 7 32-bit compatibility
WIN764ST float 8  √  null A flag to indicate the compatibilty status of the software release with regards to Windows 7 64-bit. Values: 0-7
WIN764UP varchar 255  √  null The upgrade path for the software release to attain Windows 7 64-bit compatibility
WIN764D varchar 32  √  null The date when the software release attained Windows 7 64-bit compatibility

Analyzed at Thu Oct 04 14:29 PDT 2012

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

Close relationships  within of separation: