TABLE  CombinedFilters

Contains required filters used for every programme held in the VSA.

This table describes, for every programme held in the VSA, the
combination of filters that will be used for that programme. This
information is used, for example, by curation tasks that run over
all the filters within a given programme (eg. detection merging
into a multi-colour, multi-epoch record)

Required constraints:
  • Primary key is (programmeID,mapID,filterID)
  • (programmeID) references Programme(programmeID)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
programmeIDint4 the unique programme ID meta.id
mapIDint4 the unique mapID meta.id
filterIDtinyint1 UID of combined filter meta.code
filterIDListvarchar64 List of filters as comma separated string. Optional put archive in front if filters from multiple archives: eg. WSA-1,2,3;SDSS-2,3,4  
combineTypeCodetinyint1 Code for combineType: 1:1/varSq, meta.code
Total length74