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.
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.
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.
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.
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.
Latest Revision:	9517, 2012-11-25 10:47:56 (Sun, 25 Nov 2012)