TABLE  Release

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

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

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
surveyIDint4 the unique identifier for the survey
releaseNumsmallint2 the release number
releaseDatedatetime8MM-DD-YYYYthe release date12-31-9999time.epoch
descriptionvarchar256 a brief description of the release meta.note
dbNamevarchar128 the name of the SQL Server database containing this release ??
Total length398