VSA_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.
CombinedFilters Contains required filters used for every programme held in the VSA.
CurationTask Contains a list of all curation tasks that are used within the VSA.
ExternalProduct Contains details of external products imported into archive
ExternalProductCatalogue Contains original files imported
ExternalSurvey A list of all externally produced survey products held in the archive.
ExternalSurveyTable Contains information about the external surveys tables.
Filter Contains details of the VISTA infrared camera filters.
FilterSections Contains details of the different sections of sectioned OMEGACAM filters.
MapFilterLupt Contains luptitude softening params for filters used for every MAP held in the VSA.
MapSurveyTables Contains programmes/surveys information for selection list..
PhotCalVers Contains details of all photometric calibration versions in the VSA.
ProductLinks Contains links between different products, e.g. tiles and stacks, mosaics and tiles, mosaics and stacks
Programme Contains details of the VISTA public survey 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.
RegionFieldLinks Contains details of default mosaic image products curated in the archive.
Release Contains the release details for each survey curated within the VSA.
RequiredDiffImage Contains details of default difference image products curated in the archive.
RequiredFilters Contains required filters used for every programme held in the VSA.
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 VSA.
RequiredRegion Contains details of default mosaic image products curated in the archive.
RequiredStack Contains details of default stack image products curated in the archive.
RequiredTile Contains details of default stack image products curated in the archive.
SectionDetectors Gives which detectors correspond to different sections of sectioned OMEGACAM filters.
SExtractorInputParams Contains details of Sextractor input parameters.
Survey Contains information about the curated surveys within the VSA.
SurveyProgrammes Contains details of which programme(s) belong to which survey(s)
Latest Revision:12902, 2020-11-03 16:31:13 (Tue, 3 Nov 2020)