WSA_MultiframeSchema.sql

Database schema file for multiframe images, programme and filter data in the WFCAM Science Archive. Contains sql scripts to create the relevant tables. NB: Tables are ordered by foreign key dependencies.
CurrentAstrometry Contains the current astrometric calibration coefficients.
EpochFrameStatus Contains details of which image(s) are used in epochs in mergelogs
MapFrameStatus Contains details of the processing status for each matched-aperture product frame
MapProvenance Describes the provenance of all averaged catalogues
Multiframe Contains details of all multiframes stored in the archive.
MultiframeDetector Contains details of individual detector frames that are part of a multiframe.
PreviousAstrometry Contains previous astrometric calibration coefficients.
PreviousMFDZP Contains previous zeropoints for each multiframe and detector combination.
ProblemFrames Contains details of problem multiframes.
ProgrammeFrame Contains details of which image(s) belong to which Programme(s)
Provenance Describes the provenance of all combined frames in the archive.
Latest Revision:12639, 2019-11-08 12:05:37 (Fri, 8 Nov 2019)