TABLE Survey

Basic details of the GES survey.

This table contains a single row giving basic details of the GES survey.
There is a corresponding Survey table for each (every?) survey curated
by WFAU. The Survey table drives the release of new survey products.

Required constraints:
Primary key is (surveyID)

Name Type Length Unit Description Default Value Unified Content Descriptor

surveyID int 4 The unique identifier for the curated survey meta.id

name varchar 128 A short name for the survey ??

description varchar 512 A concise description of the survey ??

dbNamePrefix varchar 32 A string that prefixes all database names released for this survey ??

equinox real 4 years Equinox of the celestial coordinates tabulated in the survey (typically 'J2000') -9.999995e+08

proprietary tinyint 1 Logical flag indicating whether a survey is proprietary or not (1=yes; 0=no) ??

Total length 681

Name	Type	Length	Unit	Description	Default Value	Unified Content Descriptor
surveyID	int	4		The unique identifier for the curated survey		meta.id
name	varchar	128		A short name for the survey		??
description	varchar	512		A concise description of the survey		??
dbNamePrefix	varchar	32		A string that prefixes all database names released for this survey		??
equinox	real	4	years	Equinox of the celestial coordinates tabulated in the survey (typically 'J2000')	-9.999995e+08
proprietary	tinyint	1		Logical flag indicating whether a survey is proprietary or not (1=yes; 0=no)		??
Total length		681