VSA_CurationLogsSchema.sql

Database schema file to create WSA curation tables in SQL. NB: Tables are ordered by foreign key dependencies.
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.
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.
RequiredFilters Contains required filters used for every programme held in the VSA.
RequiredNeighbours Details programmes/survey tables that have default joins within the VSA.
RequiredStack Contains details of default stack image products curated in the archive.
RequiredTile Contains details of default stack image products curated in the archive.
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)