TABLE Release

Contains the release details for each survey curated within the VSA.

Required constraints:
Primary key is (surveyID,releaseNum)
(surveyID) references Survey(surveyID)

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 12-31-9999 time.epoch

description varchar 256 a brief description of the release meta.note

dbName varchar 128 the name of the SQL Server database containing this release ??

Total length 398

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	12-31-9999	time.epoch
description	varchar	256		a brief description of the release		meta.note
dbName	varchar	128		the name of the SQL Server database containing this release		??
Total length		398