| Details of each release of the GES survey. |
| This table lists all the releases of the GES survey. (There is a corresponding Release table for each (every?) survey curated by WFAU.) Required constraints:
|
| Name | Type | Length | Unit | Description | Default Value | Unified Content Descriptor |
|---|---|---|---|---|---|---|
| surveyID | int | 4 | The unique identifier for the survey | meta.id | ||
| releaseNum | smallint | 2 | The release number | meta.software | ||
| releaseDate | datetime | 8 | MM-DD-YYYY | The release date | time.epoch | |
| description | varchar | 256 | A brief description of the release | 'NONE' | meta.note | |
| dbName | varchar | 128 | The name of the SQL Server database containing this release | 'NONE' | ?? | |
| deprecated | tinyint | 1 | Deprecated flag: coded as current=0 or deprecated !=0 | 0 | meta.code | |
| Total length | 399 |