| The SoftwareVersion table holds version information for software items used in the data processing. |
| The SoftwareVersion table lists all the versions of all the software items used in the GES data processing. A software item may be either an entire 'package' or a single program or application. The distinguishing characteristic of a software item is that it should be an identifiable entity. Required constraints:
|
| Name | Type | Length | Unit | Description | Default Value | Unified Content Descriptor |
|---|---|---|---|---|---|---|
| softwareID | bigint | 8 | Software (version) identifier: unique identifier for each version of each software item | -99999999 | ||
| softwareName | varchar | 20 | Name of the software item | 'NONE' | ||
| softwareVersion | varchar | 10 | Version of the software item | 'NONE' | ||
| description | varchar | 80 | Brief description of the software item | 'NONE' | ||
| institution | varchar | 20 | Institution responsible for supporting the software item | 'NONE' | ||
| reference | varchar | 40 | Bibliographic reference to a publication decribing the item | 'NONE' | ||
| url | varchar | 80 | URL for a Web page describing the item | 'NONE' | ||
| startDate | datetime | 8 | MM-DD-YYYY | Date when the item entered routine service | '31-Dec-9999' | |
| stopDate | datetime | 8 | MM-DD-YYYY | Date when the item was retired from routine service | '31-Dec-9999' | |
| deprecated | tinyint | 1 | Deprecated flag: coded as current=0 or deprecated !=0 | 0 | meta.code | |
| Total length | 275 |