TABLE  Release

Contains the release details for a survey curated within the WSA.

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 ??
publicDbvarchar128 the name of the SQL Server database containing the public releaseNONE??
Total length526