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.
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.
PhotCalVers Contains details of all photometric calibration versions in the WSA.
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.
RequiredListDrivenProduct Contains programmes/surveys required for list-driven co-located photometry.
RequiredMosaic Contains details of default mosaic image products curated in the archive.
RequiredNeighbours Details programmes/survey tables that have default joins within the WSA.
RequiredStack Contains details of default stack image products curated in the archive.
RequiredSynoptic Contains details of default synoptic tables in 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:5087, 2008-08-29 14:05:15 (Fri, 29 Aug 2008)