VSA_vhsNeighboursSchema.sql

Schema file for VHS 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.
vhsSourceNeighbours Neighbouring sources for each entry in vhsSource.
vhsSourceXallwise_sc Cross-neighbours between vhs and allwise_sc.
vhsSourceXatlasDR3 Cross-neighbours between vhs and atlasSource.
vhsSourceXDR10lasSource Cross-neighbours between vhs and lasSource.
vhsSourceXDR13PhotoObj Cross-neighbours between vhs and PhotoObj.
vhsSourceXDR13PhotoObjAll Cross-neighbours between vhs and PhotoObjAll.
vhsSourceXDR5lasSource Cross-neighbours between vhs and lasSource.
vhsSourceXDR7PhotoObj Cross-neighbours between vhs and PhotoObj.
vhsSourceXDR7PhotoObjAll Cross-neighbours between vhs and PhotoObjAll.
vhsSourceXfirstSource Cross-neighbours between vhs and firstSource12Feb16.
vhsSourceXGDR1gaia_source Cross-neighbours between vhs and gaia_source.
vhsSourceXGDR1tgas_source Cross-neighbours between vhs and tgas_source.
vhsSourceXGDR2gaia_source Cross-neighbours between vhs and gaia_source.
vhsSourceXGEDR3gaia_source Cross-neighbours between vhs and gaia_source.
vhsSourceXiras_psc Cross-neighbours between vhs and iras_psc.
vhsSourceXmgcDetection Cross-neighbours between vhs and mgcDetection.
vhsSourceXPawPrints Cross-neighbours between master source list, vhsSource table, and detections in vhsDetection table.
vhsSourceXrosat_bsc Cross-neighbours between vhs and rosat_bsc.
vhsSourceXrosat_fsc Cross-neighbours between vhs and rosat_fsc.
vhsSourceXSKYMAP_masterDR2 Cross-neighbours between vhs and masterDR2.
vhsSourceXSSASource Cross-neighbours between vhs and Source.
vhsSourceXStripe82PhotoObjAll Cross-neighbours between vhs and PhotoObjAll.
vhsSourceXtwomass_psc Cross-neighbours between vhs and twomass_psc.
vhsSourceXtwomass_sixx2_xsc Cross-neighbours between vhs and twomass_sixx2_xsc.
vhsSourceXtwomass_xsc Cross-neighbours between vhs and twomass_xsc.
vhsSourceXtwompzPhotoz Cross-neighbours between vhs and twompzPhotoz.
vhsSourceXtwoxmm Cross-neighbours between vhs and twoxmmi_dr3_v1_0.
vhsSourceXwise_allskysc Cross-neighbours between vhs and wise_allskysc.
vhsSourceXwiseScosPhotoz Cross-neighbours between vhs and wiseScosPhotoz.
Latest Revision:13540, 2024-08-09 12:37:22 (Fri, 9 Aug 2024)