| Ledger of all the external catalogues paired with the GES target catalogue. |
| This table lists all the external catalogues that have been paired with the GES target catalogue. Required constraints:
|
| Name | Type | Length | Unit | Description | Default Value | Unified Content Descriptor |
|---|---|---|---|---|---|---|
| catalogueID | bigint | 8 | Unique identifier for each external catalogue | -99999999 | ||
| catalogueName | varchar | 10 | Short name of the catalogue | 'NONE' | ||
| catalogueTableName | varchar | 40 | Table name of the catalogue in the GES schema | 'NONE' | ||
| ddlFileName | varchar | 40 | Name of the DDL file for the catalogue | 'NONE' | ||
| description | varchar | 40 | Brief description of the catalogue | 'NONE' | ||
| equinox | real | 4 | years | Equinox of the celestial coordinates tabulated in the catalogue (typically 'J2000') | -9.999995e+08 | |
| epoch | real | 4 | years | Epoch of the celestial coordinates tabulated in the catalogue | -9.999995e+08 | |
| releaseDate | datetime | 8 | MM-DD-YYYY | Date the catalogue was ingested into the GES survey | '9999-12-31 23:59:59' | |
| reference | varchar | 40 | Bibliographic reference to a publication decribing the catalogue | 'NONE' | ||
| url | varchar | 80 | URL for a Web page describing the catalogue | 'NONE' | ||
| deprecated | tinyint | 1 | Deprecated flag: coded as current=0 or deprecated !=0 | 0 | meta.code | |
| replacement | bigint | 8 | If deprecated, catalogueID of the suggested replacement catalogue (-1, ie. non-existent catalogueID, if none) | -99999999 | ||
| Total length | 283 |