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)

Name Type Length Unit Description Default Value Unified Content Descriptor

programmeID int 4 the unique programme ID meta.id

filterID tinyint 1 UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) meta.code;instr.filter

nPass smallint 2 the number of passes that will be made meta.number

isSynoptic tinyint 1 is the band observed multiple times for variability measurements (0 FALSE, 1 TRUE) 0

obReqs varchar 32 For wide shallow surveys with small number of epochs, what OB requirements for each epoch. NONE meta.note

Total length 40

Name	Type	Length	Description	Default Value	Unified Content Descriptor
programmeID	int	4	the unique programme ID		meta.id
filterID	tinyint	1	UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks)		meta.code;instr.filter
nPass	smallint	2	the number of passes that will be made		meta.number
isSynoptic	tinyint	1	is the band observed multiple times for variability measurements (0 FALSE, 1 TRUE)	0
obReqs	varchar	32	For wide shallow surveys with small number of epochs, what OB requirements for each epoch.	NONE	meta.note
Total length		40