Table BDNA_PUBLISH.dbo.CAT_SOFTWARE_LIFECYCLE
Software lifecylce 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
RELEASE_ID float 8
CAT_SOFTWARE_RELEASE.ID FK0_CAT_SOFTWARE_LIFECYCLE R
Software release's unique identifier
GENERAL_AVAILABILITY_STR varchar 60  √  null The date when the product is generally available through official vendor distributions, captured the way it was published by the vendor
GENERAL_AVAILABILITY datetime 16,3  √  null The date when the product is generally available through official vendor distributions, standardized to follow BDNA's date format
END_OF_LIFE_STR varchar 60  √  null The last date when full support for product is provided by the vendor, captured the way it was published by the vendor. Partial support is still available
END_OF_LIFE datetime 16,3  √  null The last date when full support for product is provided by the vendor, standardized to follow BDNA's date format. Partial support is still available
END_OF_LIFE_SUPPORT_LEVEL varchar 60  √  null The name of support level that marks the End of Life, captured the way it was published by the vendor
OBSOLETE_STR varchar 60  √  null The last date when any support is provided by the vendor, captured the way it was published by the vendor. The only support available after this date (if applicable) is self-help online support
OBSOLETE datetime 16,3  √  null The last date when any support is provided by the vendor, standardized to follow BDNA's date format. The only support available after this date (if applicable) is self-help online support
OBSOLETE_SUPPORT_LEVEL varchar 60  √  null The name of support level that marks the Obsolete, captured the way it was published by the vendor

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
RELEASE_ID Primary key Asc PK_CAT_SOFTWARE_LIFECYCLE
RELEASE_ID + END_OF_LIFE Performance Asc/Asc REP_IDX_IDX_CSWLIFE_1

Close relationships  within of separation: