| 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 |