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.
vmcPsfSourceXakari_lmc_psa_v1 Cross-neighbours between vmc and akari_lmc_psa_v1.
vmcPsfSourceXakari_lmc_psc_v1 Cross-neighbours between vmc and akari_lmc_psc_v1.
vmcPsfSourceXallwise_sc Cross-neighbours between vmc and allwise_sc.
vmcPsfSourceXcatwise_2020 Cross-neighbours between vmc and catwise_2020.
vmcPsfSourceXdenisDR3Source Cross-neighbours between vmc and denisDR3Source.
vmcPsfSourceXeros2LMCSource Cross-neighbours between vmc and eros2LMCSource.
vmcPsfSourceXeros2SMCSource Cross-neighbours between vmc and eros2SMCSource.
vmcPsfSourceXerosLMCSource Cross-neighbours between vmc and erosLMCSource.
vmcPsfSourceXerosSMCSource Cross-neighbours between vmc and erosSMCSource.
vmcPsfSourceXGDR1gaia_source Cross-neighbours between vmc and gaia_source.
vmcPsfSourceXGDR1tgas_source Cross-neighbours between vmc and tgas_source.
vmcPsfSourceXGDR2gaia_source Cross-neighbours between vmc and gaia_source.
vmcPsfSourceXmachoLMCSource Cross-neighbours between vmc and machoLMCSource.
vmcPsfSourceXmachoSMCSource Cross-neighbours between vmc and machoSMCSource.
vmcPsfSourceXmcps_lmcSource Cross-neighbours between vmc and mcps_lmcSource.
vmcPsfSourceXmcps_smcSource Cross-neighbours between vmc and mcps_smcSource.
vmcPsfSourceXogle3LpvLmcSource Cross-neighbours between vmc and ogle3LpvLmcSource.
vmcPsfSourceXogle3LpvSmcSource Cross-neighbours between vmc and ogle3LpvSmcSource.
vmcPsfSourceXogle4CepLmcSource Cross-neighbours between vmc and ogle4CepLmcSource.
vmcPsfSourceXogle4CepSmcSource Cross-neighbours between vmc and ogle4CepSmcSource.
vmcPsfSourceXogle4RRLyrLmcSource Cross-neighbours between vmc and ogle4RRLyrLmcSource.
vmcPsfSourceXogle4RRLyrSmcSource Cross-neighbours between vmc and ogle4RRLyrSmcSource.
vmcPsfSourceXravedr5Source Cross-neighbours between vmc and ravedr5Source.
vmcPsfSourceXsage_lmcIracSource Cross-neighbours between vmc and sage_lmcIracSource.
vmcPsfSourceXsage_lmcMips160Source Cross-neighbours between vmc and sage_lmcMips160Source.
vmcPsfSourceXsage_lmcMips24Source Cross-neighbours between vmc and sage_lmcMips24Source.
vmcPsfSourceXsage_lmcMips70Source Cross-neighbours between vmc and sage_lmcMips70Source.
vmcPsfSourceXSKYMAP_masterDR2 Cross-neighbours between vmc and masterDR2.
vmcPsfSourceXspitzer_smcSource Cross-neighbours between vmc and spitzer_smcSource.
vmcPsfSourceXSSASource Cross-neighbours between vmc and Source.
vmcPsfSourceXtwomass_psc Cross-neighbours between vmc and twomass_psc.
vmcPsfSourceXtwomass_sixx2_psc Cross-neighbours between vmc and twomass_sixx2_psc.
vmcPsfSourceXtwomass_sixx2_xsc Cross-neighbours between vmc and twomass_sixx2_xsc.
vmcPsfSourceXtwomass_xsc Cross-neighbours between vmc and twomass_xsc.
vmcPsfSourceXtwompzPhotoz Cross-neighbours between vmc and twompzPhotoz.
vmcPsfSourceXwise_allskysc Cross-neighbours between vmc and wise_allskysc.
vmcPsfSourceXwiseScosPhotoz Cross-neighbours between vmc and wiseScosPhotoz.
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.
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.
vmcSourceXPsfSource Cross-neighbours between master source list, vmcSource table, and detections in vmcPsfSource table.
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.
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:13076, 2021-06-04 15:47:18 (Fri, 4 Jun 2021)