WSA_uhsSchema.sql

Database schema file for UKIRT Hemisphere Survey (UHS) catalogue data in the WFCAM Science Archive. Contains SQL scripts to create the relevant tables.
uhsAstrometricInfo Contains astrometric information that will be used in linking up epochs
uhsDetection Contains the individual UHS source detections for all science frame types in UHS including pawprint stacks, deep stacks.
uhsDetectionAll Contains the individual UHS source detections for all science frame types in UHS including pawprint stacks, deep stacks. Also contains detections with high ppErrBits removed from uhsDetection and deprecated detections.
uhsMergeLog Contains frame set details of merged UHS MultiframeDetector images.
uhsOrphan Contains bright detections that are missing in the BestMatch table.
uhsSource Contains merged sources from detections in uhsDetection.
uhsSourceAll Contains merged sources from detections in uhsDetection. Includes detections with high ppErrBits removed from uhsSource.
uhsSourceXDetectionBestMatch Links each unique source in uhsSource to each stack epoch in Multiframe (or uhsDetection).
uhsVarFrameSetInfo Contains photometric and astrometric noise fitting information for each frameSet.
uhsVariability Contains statistical analysis of UHS primary sources.
Latest Revision:13165, 2021-12-02 17:51:12 (Thu, 2 Dec 2021)