WSA_NeighboursSchema.sql

Schema file for UKIDSS neighbour and cross-neighbour tables in the WSA. 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.
dxsSourceNeighbours Neighbouring sources for each entry in dxsSource.
dxsSourceXDetection Cross-neighbours between master source list (from deep stacks) and the Detection table (all intermediate and deep stacks).
dxsSourceXDR7PhotoObj Cross-neighbours between UKIDSS DXS and SDSS DR7 sources.
dxsSourceXtwomass_psc Cross-neighbours between dxsSource and the 2MASS point source catalogue.
dxsSourceXtwoxmm Cross-neighbours between dxsSource and 2XMM sources.
gcsSourceNeighbours Neighbouring sources for each entry in gcsSource.
gcsSourceXDR5PhotoObj Cross-neighbours between UKIDSS GCS and SDSS DR5 sources.
gcsSourceXDR7PhotoObj Cross-neighbours between UKIDSS GCS and SDSS DR7 sources.
gcsSourceXtwomass_psc Cross-neighbours between gcsSource and the 2MASS point source catalogue.
gcsSourceXtwoxmm Cross-neighbours between gcsSource and 2XMM sources.
gpsSourceNeighbours Neighbouring sources for each entry in gpsSource.
gpsSourceXglimpse1_hrc Cross-neighbours between gpsSource and the GLIMPSEI Highly Reliable Catalogue (v2.0).
gpsSourceXglimpse1_mca Cross-neighbours between gpsSource and the GLIMPSEI More Complete Archive (v2.0).
gpsSourceXglimpse2_hrc Cross-neighbours between gpsSource and the GLIMPSEII Highly Reliable Catalogue (v2.0).
gpsSourceXglimpse2_mca Cross-neighbours between gpsSource and the GLIMPSEII More Complete Archive (v2.0).
gpsSourceXglimpse_hrc_inter Cross-neighbours between gpsSource and the GLIMPSEI Highly Reliable Catalogue (intermediate).
gpsSourceXglimpse_mca_inter Cross-neighbours between gpsSource and the GLIMPSEI More Complete Archive (intermediate).
gpsSourceXtwomass_psc Cross-neighbours between gpsSource and the 2MASS point source catalogue.
gpsSourceXtwoxmm Cross-neighbours between gpsSource and 2XMM sources.
lasSourceNeighbours Neighbouring sources for each entry in lasSource.
lasSourceXDR2PhotoObj Cross-neighbours between UKIDSS LAS and SDSS DR2 sources.
lasSourceXDR3PhotoObj Cross-neighbours between UKIDSS LAS and SDSS DR3 sources.
lasSourceXDR5PhotoObj Cross-neighbours between UKIDSS LAS and SDSS DR5 sources.
lasSourceXDR5PhotoObjAll Cross-neighbours between UKIDSS LAS and SDSS DR5 complete sources.
lasSourceXDR7PhotoObj Cross-neighbours between UKIDSS LAS and SDSS DR7 sources.
lasSourceXDR7PhotoObjAll Cross-neighbours between UKIDSS LAS and SDSS DR7 complete sources.
lasSourceXfirstSource Cross-neighbours between lasSource and the FIRST source catalogue.
lasSourceXiras_psc Cross-neighbours between lasSource and the IRAS point source catalogue.
lasSourceXmgcDetection Cross-neighbours between lasSource and Millennium Galaxy Catalogue Detections.
lasSourceXnvssSource Cross-neighbours between lasSource and the NVSS source catalogue.
lasSourceXrosat_bsc Cross-neighbours between lasSource and the ROSAT bright source catalogue.
lasSourceXrosat_fsc Cross-neighbours between lasSource and the ROSAT faint source catalogue.
lasSourceXSegueDR6PhotoObj Cross-neighbours between UKIDSS LAS and SDSS Segue DR6 sources.
lasSourceXSegueDR6PhotoObjAll Cross-neighbours between UKIDSS LAS and SDSS Segue DR6 complete sources.
lasSourceXtwomass_psc Cross-neighbours between lasSource and the 2MASS point source catalogue.
lasSourceXtwomass_xsc Cross-neighbours between lasSource and the 2MASS extended source catalogue.
lasSourceXtwoxmm Cross-neighbours between lasSource and 2XMM sources.
udsSourceNeighbours Neighbouring sources for each entry in udsSource.
udsSourceXDetection Cross-neighbours between master source list (from deep mosaic) and the Detection table (all intermediate and deep stacks).
udsSourceXtwomass_psc Cross-neighbours between udsSource and the 2MASS point source catalogue.
udsSourceXtwoxmm Cross-neighbours between udsSource and 2XMM sources.
Latest Revision:5626, 2009-04-08 10:27:31 (Wed, 8 Apr 2009)