TABLE  RequiredFilters

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 (e.g. detection merging
into a multi-colour, multi-epoch record)

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

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
programmeIDint4 the unique programme ID
filterIDtinyint1 UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) meta.code;instr.filter
nPasssmallint2 the number of passes that will be made meta.number
isSynoptictinyint1 is the band observed multiple times for variability measurements (0 FALSE, 1 TRUE)0 
Total length8