VSA_sharksNeighboursSchema.sql

Schema file for SHARKS 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.
sharksSourceNeighbours Neighbouring sources for each entry in sharksSource.
sharksSourceXallwise_sc Cross-neighbours between sharks and allwise_sc.
sharksSourceXDetection Cross-neighbours between master source list, sharksSource table, and the individual epoch detections, sharksDetection table.
sharksSourceXSSASource Cross-neighbours between sharks and Source.
sharksSourceXtwomass_psc Cross-neighbours between sharks and twomass_psc.
sharksSourceXtwompzPhotoz Cross-neighbours between sharks and twompzPhotoz.
sharksSourceXwise_allskysc Cross-neighbours between sharks and wise_allskysc.
sharksSourceXwiseScosPhotoz Cross-neighbours between sharks and wiseScosPhotoz.
Latest Revision:12017, 2018-01-23 12:27:45 (Tue, 23 Jan 2018)