TABLE  RequiredMergeLogMultiEpoch

Contains details of filter epochs in MergeLog table products.

This table contains details of all products that describe single epoch OB
frames in the mergelog/source tables. These are only for the cases
when RequiredFilters has numEpochs>=2, for instance VIKING J-band data

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

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
programmeIDint4 the unique programme ID meta.id
productTypevarchar16 Product type (stack,tile,mosaic)  
productIDint4 A unique identifier assigned to each required stack product entry ??
namevarchar64 Name of the stacked product ??
descriptionvarchar256 Description of the product ??
fieldIDint4 UID of position on sky. References Required{productType}.fieldID-99999999??
filterIDtinyint1 UID of combined filter (assigned in OSA: 1=u,2=g,3=r,4=i,5=z,6=blank) meta.code;instr.filter
epochtinyint1 Epoch number in MergeLog table  
Total length350