VSA_vvvNeighboursSchema.sql

Schema file for VVV 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.
vvvPsfDaophotJKsSourceXallwise_sc Cross-neighbours between vvv and allwise_sc.
vvvPsfDaophotJKsSourceXdecapsSource Cross-neighbours between vvv and decapsSource.
vvvPsfDaophotJKsSourceXDR11gpsSource Cross-neighbours between vvv and gpsSource.
vvvPsfDaophotJKsSourceXDR8gpsSource Cross-neighbours between vvv and gpsSource.
vvvPsfDaophotJKsSourceXGDR1gaia_source Cross-neighbours between vvv and gaia_source.
vvvPsfDaophotJKsSourceXGDR1tgas_source Cross-neighbours between vvv and tgas_source.
vvvPsfDaophotJKsSourceXGDR2gaia_source Cross-neighbours between vvv and gaia_source.
vvvPsfDaophotJKsSourceXglimpse1_hrc Cross-neighbours between vvv and glimpse1_hrc.
vvvPsfDaophotJKsSourceXglimpse1_mca Cross-neighbours between vvv and glimpse1_mca.
vvvPsfDaophotJKsSourceXglimpse2_hrc Cross-neighbours between vvv and glimpse2_hrc.
vvvPsfDaophotJKsSourceXglimpse2_mca Cross-neighbours between vvv and glimpse2_mca.
vvvPsfDaophotJKsSourceXiras_psc Cross-neighbours between vvv and iras_psc.
vvvPsfDaophotJKsSourceXSSASource Cross-neighbours between vvv and Source.
vvvPsfDaophotJKsSourceXtwomass_psc Cross-neighbours between vvv and twomass_psc.
vvvPsfDaophotJKsSourceXtwomass_xsc Cross-neighbours between vvv and twomass_xsc.
vvvPsfDaophotJKsSourceXvphasDr3Source Cross-neighbours between vvv and vphasSource.
vvvPsfDaophotJKsSourceXwise_allskysc Cross-neighbours between vvv and wise_allskysc.
vvvPsfDaophotJKsSourceXxmm3dr4 Cross-neighbours between vvv and xmm3dr4.
vvvPsfDophotZYJHKsSourceXallwise_sc Cross-neighbours between vvv and allwise_sc.
vvvPsfDophotZYJHKsSourceXdecapsSource Cross-neighbours between vvv and decapsSource.
vvvPsfDophotZYJHKsSourceXDR11gpsSource Cross-neighbours between vvv and gpsSource.
vvvPsfDophotZYJHKsSourceXDR8gpsSource Cross-neighbours between vvv and gpsSource.
vvvPsfDophotZYJHKsSourceXGDR1gaia_source Cross-neighbours between vvv and gaia_source.
vvvPsfDophotZYJHKsSourceXGDR1tgas_source Cross-neighbours between vvv and tgas_source.
vvvPsfDophotZYJHKsSourceXGDR2gaia_source Cross-neighbours between vvv and gaia_source.
vvvPsfDophotZYJHKsSourceXglimpse1_hrc Cross-neighbours between vvv and glimpse1_hrc.
vvvPsfDophotZYJHKsSourceXglimpse1_mca Cross-neighbours between vvv and glimpse1_mca.
vvvPsfDophotZYJHKsSourceXglimpse2_hrc Cross-neighbours between vvv and glimpse2_hrc.
vvvPsfDophotZYJHKsSourceXglimpse2_mca Cross-neighbours between vvv and glimpse2_mca.
vvvPsfDophotZYJHKsSourceXiras_psc Cross-neighbours between vvv and iras_psc.
vvvPsfDophotZYJHKsSourceXSSASource Cross-neighbours between vvv and Source.
vvvPsfDophotZYJHKsSourceXtwomass_psc Cross-neighbours between vvv and twomass_psc.
vvvPsfDophotZYJHKsSourceXtwomass_xsc Cross-neighbours between vvv and twomass_xsc.
vvvPsfDophotZYJHKsSourceXvphasDr3Source Cross-neighbours between vvv and vphasSource.
vvvPsfDophotZYJHKsSourceXwise_allskysc Cross-neighbours between vvv and wise_allskysc.
vvvPsfDophotZYJHKsSourceXxmm3dr4 Cross-neighbours between vvv and xmm3dr4.
vvvSourceNeighbours Neighbouring sources for each entry in vvvSource.
vvvSourceXallwise_sc Cross-neighbours between vvv and allwise_sc.
vvvSourceXdecapsSource Cross-neighbours between vvv and decapsSource.
vvvSourceXDetection Cross-neighbours between master source list, vvvSource table, and the individual epoch detections, vvvDetection table.
vvvSourceXDR11gpsSource Cross-neighbours between vvv and gpsSource.
vvvSourceXDR8gpsSource Cross-neighbours between vvv and gpsSource.
vvvSourceXGDR1gaia_source Cross-neighbours between vvv and gaia_source.
vvvSourceXGDR1tgas_source Cross-neighbours between vvv and tgas_source.
vvvSourceXGDR2gaia_source Cross-neighbours between vvv and gaia_source.
vvvSourceXglimpse1_hrc Cross-neighbours between vvv and glimpse1_hrc.
vvvSourceXglimpse1_mca Cross-neighbours between vvv and glimpse1_mca.
vvvSourceXglimpse2_hrc Cross-neighbours between vvv and glimpse2_hrc.
vvvSourceXglimpse2_mca Cross-neighbours between vvv and glimpse2_mca.
vvvSourceXiras_psc Cross-neighbours between vvv and iras_psc.
vvvSourceXParallaxCatalogue Cross-neighbours between master source list, vvvSource table, and detections in vvvParallaxCatalogue table.
vvvSourceXProperMotionCatalogue Cross-neighbours between master source list, vvvSource table, and detections in vvvProperMotionCatalogue table.
vvvSourceXPsfDaophotJKsSource Cross-neighbours between master source list, vvvSource table, and detections in vvvPsfDaophotJKsSource table.
vvvSourceXPsfDophotZYJHKsSource Cross-neighbours between master source list, vvvSource table, and detections in vvvPsfDophotZYJHKsSource table.
vvvSourceXSSASource Cross-neighbours between vvv and Source.
vvvSourceXtwomass_psc Cross-neighbours between vvv and twomass_psc.
vvvSourceXtwomass_xsc Cross-neighbours between vvv and twomass_xsc.
vvvSourceXVivaCatalogue Cross-neighbours between master source list, vvvSource table, and detections in vvvVivaCatalogue table.
vvvSourceXvphasDr3Source Cross-neighbours between vvv and vphasSource.
vvvSourceXwise_allskysc Cross-neighbours between vvv and wise_allskysc.
vvvSourceXxmm3dr4 Cross-neighbours between vvv and xmm3dr4.
Latest Revision:12798, 2020-05-06 22:26:51 (Wed, 6 May 2020)