VSA_vmcNeighboursSchema.sql

Schema file for VMC 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.
vmcSourceNeighbours Neighbouring sources for each entry in vmcSource.
vmcSourceXakari_lmc_psa_v1 Cross-neighbours between vmc and akari_lmc_psa_v1.
vmcSourceXakari_lmc_psc_v1 Cross-neighbours between vmc and akari_lmc_psc_v1.
vmcSourceXallwise_sc Cross-neighbours between vmc and allwise_sc.
vmcSourceXcatwise_2020 Cross-neighbours between vmc and catwise_2020.
vmcSourceXdenisDR3Source Cross-neighbours between vmc and denisDR3Source.
vmcSourceXeros2LMCSource Cross-neighbours between vmc and eros2LMCSource.
vmcSourceXeros2SMCSource Cross-neighbours between vmc and eros2SMCSource.
vmcSourceXerosLMCSource Cross-neighbours between vmc and erosLMCSource.
vmcSourceXerosSMCSource Cross-neighbours between vmc and erosSMCSource.
vmcSourceXGDR1gaia_source Cross-neighbours between vmc and gaia_source.
vmcSourceXGDR1tgas_source Cross-neighbours between vmc and tgas_source.
vmcSourceXGDR2gaia_source Cross-neighbours between vmc and gaia_source.
vmcSourceXGEDR3gaia_source Cross-neighbours between vmc and gaia_source.
vmcSourceXmachoLMCSource Cross-neighbours between vmc and machoLMCSource.
vmcSourceXmachoSMCSource Cross-neighbours between vmc and machoSMCSource.
vmcSourceXmcps_lmcSource Cross-neighbours between vmc and mcps_lmcSource.
vmcSourceXmcps_smcSource Cross-neighbours between vmc and mcps_smcSource.
vmcSourceXogle3LpvLmcSource Cross-neighbours between vmc and ogle3LpvLmcSource.
vmcSourceXogle3LpvSmcSource Cross-neighbours between vmc and ogle3LpvSmcSource.
vmcSourceXogle4CepLmcSource Cross-neighbours between vmc and ogle4CepLmcSource.
vmcSourceXogle4CepSmcSource Cross-neighbours between vmc and ogle4CepSmcSource.
vmcSourceXogle4RRLyrLmcSource Cross-neighbours between vmc and ogle4RRLyrLmcSource.
vmcSourceXogle4RRLyrSmcSource Cross-neighbours between vmc and ogle4RRLyrSmcSource.
vmcSourceXravedr5Source Cross-neighbours between vmc and ravedr5Source.
vmcSourceXsage_lmcIracSource Cross-neighbours between vmc and sage_lmcIracSource.
vmcSourceXsage_lmcMips160Source Cross-neighbours between vmc and sage_lmcMips160Source.
vmcSourceXsage_lmcMips24Source Cross-neighbours between vmc and sage_lmcMips24Source.
vmcSourceXsage_lmcMips70Source Cross-neighbours between vmc and sage_lmcMips70Source.
vmcSourceXSKYMAP_masterDR2 Cross-neighbours between vmc and masterDR2.
vmcSourceXSMASHDR2_deep Cross-neighbours between vmc and smashdr2_deep.
vmcSourceXSMASHDR2_object Cross-neighbours between vmc and smashdr2_object.
vmcSourceXSMASHDR2_source Cross-neighbours between vmc and smashdr2_source.
vmcSourceXspitzer_smcSource Cross-neighbours between vmc and spitzer_smcSource.
vmcSourceXSSASource Cross-neighbours between vmc and Source.
vmcSourceXSynopticSource Cross-neighbours between master source list, vmcSource table, and the individual epoch detections, vmcSynopticSource table.
vmcSourceXtwomass_psc Cross-neighbours between vmc and twomass_psc.
vmcSourceXtwomass_sixx2_psc Cross-neighbours between vmc and twomass_sixx2_psc.
vmcSourceXtwomass_sixx2_xsc Cross-neighbours between vmc and twomass_sixx2_xsc.
vmcSourceXtwomass_xsc Cross-neighbours between vmc and twomass_xsc.
vmcSourceXtwompzPhotoz Cross-neighbours between vmc and twompzPhotoz.
vmcSourceXVariablesType Cross-neighbours between master source list, vmcSource table, and detections in vmcVariablesType table.
vmcSourceXwise_allskysc Cross-neighbours between vmc and wise_allskysc.
vmcSourceXwiseScosPhotoz Cross-neighbours between vmc and wiseScosPhotoz.
Latest Revision:13395, 2023-09-22 14:07:11 (Fri, 22 Sep 2023)