TABLE  ExternalSurveyTable

Contains information about the external surveys tables.

Each external survey database will consist of several tables that may
need to be explicitly recorded for the purposes of various curation
tasks. This table contains a matrix of external surveys and their
tables stored within the archive.

Required constraints:
  • Primary key is (surveyID,extTableID)
  • (surveyID) references ExternalSurvey(surveyID)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
surveyIDint4 the unique identifier for the survey meta.id
extTableIDint4 the unique table ID meta.id;meta.main
extTableNamevarchar256 the name of the table meta.id;meta.dataset
zonesmallint2 default (0) or special (n) zone obs.field
sourceIDNamevarchar256 The source unique identifier in the table meta.id
coord1varchar32 The attribute name of the first (longitudinal) spherical co-ordinate, e.g. equatorial RA ??
coord2varchar32 The attribute name of the second (latitudinal) spherical co-ordinate, e.g. equatorial Dec ??
Total length586