TABLE  RequiredFilters

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

This table describes, for every programme held in the WSA, 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,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 WSA: 1=Z,2=Y,3=J,4=H,5=K,6=H2,7=Br,8=blank) 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 
obReqsvarchar32 For wide shallow surveys with small number of epochs, what MSB requirements for each epoch.NONEmeta.note
Total length40