WSA_CurationLogsSchema.sql

Database schema file to create WSA curation tables in SQL. NB: Tables are ordered by foreign key dependencies.
ArchiveCurationHistory Contains details of the matrix of the Archives' required curation tasks.
AstrCalVers Contains a record for every astrometric calibration version in the archive.
CurationTask Contains a list of all curation tasks that are used within the WSA.
ExternalProduct Contains details of external products imported into archive
ExternalSurvey A list of all externally produced survey products held in the WSA.
ExternalSurveyTable Contains information about the external surveys tables.
Filter Contains details of the WFCAM filters.
MapSurveyTables Contains programmes/surveys information for selection list..
PhotCalVers Contains details of all photometric calibration versions in the WSA.
ProductLinks Contains links between different products, e.g. tiles and stacks, mosaics and tiles, mosaics and stacks
Programme Contains details of the WFCAM observation programmes.
ProgrammeCurationHistory Contains details of the matrix of programmes and required curation tasks.
ProgrammeTable Contains details of the set of curated tables for each programme.
Release Contains the release details for a survey curated within the WSA.
RequiredDiffImage Contains details of default difference image products curated in the archive.
RequiredFilters Contains required filters used for every programme held in the WSA.
RequiredMapAverages Contains details of averaging setup.
RequiredMatchedApertureProduct Contains highest level information required for co-located photometry
RequiredMergeLogMultiEpoch Contains details of filter epochs in MergeLog table products.
RequiredMosaic Contains details of default mosaic image products curated in the archive.
RequiredMosaicTopLevel Contains details of default mosaic image products curated in the archive.
RequiredNeighbours Details programmes/survey tables that have default joins within the WSA.
RequiredRegion Contains details of default mosaic image products curated in the archive.
RequiredStack Contains details of default stack image products curated in the archive.
Survey Contains information about the curated surveys within the WSA.
SurveyProgrammes Contains details of which programme(s) belong to which survey(s)
Latest Revision:12645, 2019-11-08 16:12:03 (Fri, 8 Nov 2019)