VSA_ultravistaNeighboursSchema.sql

Schema file for ULTRAVISTA neighbour and cross-neighbour tables NOTE: This schema is not part of the CreateTables set-up for the archive since the table definitions herein are created on-the-fly by the curation procedure (CU16). This file is parsed by CU16 to create the neighbour tables, and also for the web html documentation. For every entry in the table RequiredNeighbours, there should be a parsable table schema in this file.
ultravistaSourceNeighbours Neighbouring sources for each entry in ultravistaSource.
ultravistaSourceXallwise_sc Cross-neighbours between ultravista and allwise_sc.
ultravistaSourceXDetection Cross-neighbours between master source list, ultravistaSource table, and the individual epoch detections, ultravistaDetection table.
ultravistaSourceXDR13PhotoObj Cross-neighbours between ultravista and PhotoObj.
ultravistaSourceXDR13PhotoObjAll Cross-neighbours between ultravista and PhotoObjAll.
ultravistaSourceXGDR2gaia_source Cross-neighbours between ultravista and gaia_source.
ultravistaSourceXravedr5Source Cross-neighbours between ultravista and ravedr5Source.
ultravistaSourceXSSASource Cross-neighbours between ultravista and Source.
ultravistaSourceXtwomass_psc Cross-neighbours between ultravista and twomass_psc.
ultravistaSourceXtwompzPhotoz Cross-neighbours between ultravista and twompzPhotoz.
ultravistaSourceXwise_allskysc Cross-neighbours between ultravista and wise_allskysc.
ultravistaSourceXwiseScosPhotoz Cross-neighbours between ultravista and wiseScosPhotoz.
Latest Revision:12395, 2019-02-04 14:57:19 (Mon, 4 Feb 2019)