Table BDNA_PUBLISH.dbo.CAT_SW_REL_SUPP_STAGE
Release Support stage 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_SW_REL_SUPP_STAGE table's unique identifier
LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
RELEASE_ID float 8  √  null
CAT_SOFTWARE_RELEASE.ID FK0_CAT_SW_REL_SUPP_STAGE R
Software release's unique identifier
SUPPORT_STAGE_ID float 8  √  null
CAT_SUPPORT_STAGE.ID FK1_CAT_SW_REL_SUPP_STAGE R
Software support stage's unique identifier
STAGE_NAME varchar 60  √  null The name of the support stage/level, captured the way it was published by the vendor
STAGEORDER float 8  √  null The order the support stage/level
PUBLISHED_ENDDATE varchar 60  √  null The date that marks the end of the support stage/level, captured the way it was published by the vendor
DATE_ENDDATE datetime 16,3  √  null The date that marks the end of the support stage/level, normalized to follow BDNA's date format

Analyzed at Thu Oct 04 14:29 PDT 2012

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

Close relationships  within of separation: