VSA_vmcdeepSchema.sql

Database schema file for VMCDEEP (VMCDEEP) catalogue data in the VISTA Science Archive. Contains SQL scripts to create the relevant tables.
vmcdeepAstrometricInfo Contains astrometric information that will be used in linking up epochs. This table is mainly for use by software to link up epochs efficiently
vmcdeepDetection Contains the individual VMCDEEP source detections for all science frame types in VMCDEEP including pawprints, tiles, and deeps.
vmcdeepMergeLog Contains frame set details of merged VMCDEEP MultiframeDetector images.
vmcdeepSource Contains merged sources from detections in vmcdeepDetection.
vmcdeepSourceXSynopticSourceBestMatch Links each unique source in vmcdeepSource to each band-merged epoch in vmcdeepSynopticSource
vmcdeepSynopticMergeLog Contains details of the merged MultiframeDetector images for VMCDEEP merged to give contemporaneous or semi-contemporaneous colours
vmcdeepSynopticSource Contains VMCDEEP merged sources from VMCDEEP detections in vmcdeepDetection.
vmcdeepTilePawPrints Contains tile<->paw-print paired detections from vmcdeepDetection.
vmcdeepTileSet Contains tile set details for VMCDEEP Multiframe paw-print images.
vmcdeepVarFrameSetInfo Contains photometric and astrometric noise fitting information for each frameSet.
vmcdeepVariability Contains statistical analysis of VMCDEEP primary sources.
Latest Revision:13358, 2023-06-14 08:49:34 (Wed, 14 Jun 2023)