Table BDNA_PUBLISH.dbo.CAT_HARDWARE_LIFECYCLE
Hardware 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
MODEL_ID float 8
CAT_HARDWARE_MODEL.ID FK0_CAT_HARDWARE_LIFECYCLE R
Hardware model's unique identifier
INTRODUCTION_STR varchar 30  √  null The date the hardware was introduced/announced, captured the way it was published by the vendor
INTRODUCTION datetime 16,3  √  null The date the hardware was introduced/announced, standardized to follow BDNA's date format
GENERAL_AVAILABILITY_STR varchar 30  √  null The date the hardware was available for sale, captured the way it was published by the vendor
GENERAL_AVAILABILITY datetime 16,3  √  null The date the hardware was available for sale, standardized to follow BDNA's date format
LAST_AVAILABILITY_STR varchar 30  √  null The last date the hardware is available for purchase from the vendor, captured the way it was published by the vendor
LAST_AVAILABILITY datetime 16,3  √  null The last date the hardware is available for purchase from the vendor, standardized to follow BDNA's date format
OBSOLETE_STR varchar 30  √  null
OBSOLETE datetime 16,3  √  null The date when any form of support from the vendor ceases to exist, 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
MODEL_ID Primary key Asc PK_CAT_HARDWARE_LIFECYCLE

Close relationships  within of separation: