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 meta.id
releaseNumsmallint2 the release number meta.software
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 ??
publicDbvarchar128 the name of the SQL Server database containing the public releaseNONE??
Total length526