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.
vmcPsfCatalogueXakari_lmc_psa_v1 Cross-neighbours between vmc and akari_lmc_psa_v1.
vmcPsfCatalogueXakari_lmc_psc_v1 Cross-neighbours between vmc and akari_lmc_psc_v1.
vmcPsfCatalogueXallwise_sc Cross-neighbours between vmc and allwise_sc.
vmcPsfCatalogueXdenisDR3Source Cross-neighbours between vmc and denisDR3Source.
vmcPsfCatalogueXeros2LMCSource Cross-neighbours between vmc and eros2LMCSource.
vmcPsfCatalogueXeros2SMCSource Cross-neighbours between vmc and eros2SMCSource.
vmcPsfCatalogueXerosLMCSource Cross-neighbours between vmc and erosLMCSource.
vmcPsfCatalogueXerosSMCSource Cross-neighbours between vmc and erosSMCSource.
vmcPsfCatalogueXGDR1gaia_source Cross-neighbours between vmc and gaia_source.
vmcPsfCatalogueXGDR1tgas_source Cross-neighbours between vmc and tgas_source.
vmcPsfCatalogueXmachoLMCSource Cross-neighbours between vmc and machoLMCSource.
vmcPsfCatalogueXmachoSMCSource Cross-neighbours between vmc and machoSMCSource.
vmcPsfCatalogueXmcps_lmcSource Cross-neighbours between vmc and mcps_lmcSource.
vmcPsfCatalogueXmcps_smcSource Cross-neighbours between vmc and mcps_smcSource.
vmcPsfCatalogueXogle3LpvLmcSource Cross-neighbours between vmc and ogle3LpvLmcSource.
vmcPsfCatalogueXogle3LpvSmcSource Cross-neighbours between vmc and ogle3LpvSmcSource.
vmcPsfCatalogueXogle4CepLmcSource Cross-neighbours between vmc and ogle4CepLmcSource.
vmcPsfCatalogueXogle4CepSmcSource Cross-neighbours between vmc and ogle4CepSmcSource.
vmcPsfCatalogueXogle4RRLyrLmcSource Cross-neighbours between vmc and ogle4RRLyrLmcSource.
vmcPsfCatalogueXogle4RRLyrSmcSource Cross-neighbours between vmc and ogle4RRLyrSmcSource.
vmcPsfCatalogueXsage_lmcIracSource Cross-neighbours between vmc and sage_lmcIracSource.
vmcPsfCatalogueXsage_lmcMips160Source Cross-neighbours between vmc and sage_lmcMips160Source.
vmcPsfCatalogueXsage_lmcMips24Source Cross-neighbours between vmc and sage_lmcMips24Source.
vmcPsfCatalogueXsage_lmcMips70Source Cross-neighbours between vmc and sage_lmcMips70Source.
vmcPsfCatalogueXspitzer_smcSource Cross-neighbours between vmc and spitzer_smcSource.
vmcPsfCatalogueXSSASource Cross-neighbours between vmc and Source.
vmcPsfCatalogueXtwomass_psc Cross-neighbours between vmc and twomass_psc.
vmcPsfCatalogueXtwomass_sixx2_psc Cross-neighbours between vmc and twomass_sixx2_psc.
vmcPsfCatalogueXtwomass_sixx2_xsc Cross-neighbours between vmc and twomass_sixx2_xsc.
vmcPsfCatalogueXtwomass_xsc Cross-neighbours between vmc and twomass_xsc.
vmcPsfCatalogueXtwompzPhotoz Cross-neighbours between vmc and twompzPhotoz.
vmcPsfCatalogueXwise_allskysc Cross-neighbours between vmc and wise_allskysc.
vmcPsfCatalogueXwiseScosPhotoz 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.
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.
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.
vmcSourceXPsfCatalogue Cross-neighbours between master source list, vmcSource table, and the individual epoch detections, vmcPsfCatalogue table.
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.
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 the individual epoch detections, vmcVariablesType table.
vmcSourceXwise_allskysc Cross-neighbours between vmc and wise_allskysc.
vmcSourceXwiseScosPhotoz Cross-neighbours between vmc and wiseScosPhotoz.
Latest Revision:11890, 2017-10-26 22:35:47 (Thu, 26 Oct 2017)