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:
|
Name | Type | Length | Unit | Description | Default Value | Unified Content Descriptor |
---|---|---|---|---|---|---|
surveyID | int | 4 | the unique identifier for the survey | ID_SURVEY | ||
extTableID | int | 4 | the unique table ID | ID_MAIN | ||
extTableName | varchar | 256 | the name of the table | ID_TABLE | ||
zone | smallint | 2 | default (0) or special (n) zone | ID_REGION | ||
sourceIDName | varchar | 256 | The source unique identifier in the table | ID_TARGET | ||
coord1 | varchar | 32 | The attribute name of the first (longitudinal) spherical co-ordinate, e.g. equatorial RA | ?? | ||
coord2 | varchar | 32 | The attribute name of the second (latitudinal) spherical co-ordinate, e.g. equatorial Dec | ?? | ||
Total length | 586 |