OSA_CurationLogsSchema.sql

Database schema file to create OSA 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 OSA.
ExternalSurvey A list of all externally produced survey products held in the OSA.
ExternalSurveyTable Contains information about the external surveys tables.
Filter Contains details of the OMEGACAM filters.
FilterSections Contains details of the different sections of sectioned OMEGACAM filters.
PhotCalVers Contains details of all photometric calibration versions in the OSA.
ProductLinks Contains links between different products, e.g. tiles and stacks, mosaics and tiles, mosaics and stacks
Programme Contains details of the OMEGACAM 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 OSA.
RequiredDiffImage Contains details of default difference image products curated in the archive.
RequiredFilters Contains required filters used for every programme held in the OSA.
RequiredListDrivenProduct Contains programmes/surveys required for list-driven co-located photometry.
RequiredNeighbours Details programmes/survey tables that have default joins within the OSA.
RequiredStack Contains details of default stack image products curated in the archive.
SectionDetectors Gives which detectors correspond to different sections of sectioned OMEGACAM filters.
Survey Contains information about the curated surveys within the OSA.
SurveyProgrammes Contains details of which programme(s) belong to which survey(s)
Latest Revision:10163, 2013-12-17 14:06:01 (Tue, 17 Dec 2013)