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 LAS J-band data

Required constraints:
Primary key is (programmeID,productType,productID)
(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

productType varchar 16 Product type (stack,tile,mosaic)

productID int 4 A unique identifier assigned to each required stack product entry ??

name varchar 64 Name of the stacked product ??

description varchar 256 Description of the product ??

fieldID int 4 UID of position on sky. References Required{productType}.fieldID -99999999 ??

filterID tinyint 1 UID of combined filter (assigned in OSA: 1=u,2=g,3=r,4=i,5=z,6=blank) meta.code;instr.filter

epoch tinyint 1 Epoch number in MergeLog table

Total length 350

Name	Type	Length	Description	Default Value	Unified Content Descriptor
programmeID	int	4	the unique programme ID		meta.id
productType	varchar	16	Product type (stack,tile,mosaic)
productID	int	4	A unique identifier assigned to each required stack product entry		??
name	varchar	64	Name of the stacked product		??
description	varchar	256	Description of the product		??
fieldID	int	4	UID of position on sky. References Required{productType}.fieldID	-99999999	??
filterID	tinyint	1	UID of combined filter (assigned in OSA: 1=u,2=g,3=r,4=i,5=z,6=blank)		meta.code;instr.filter
epoch	tinyint	1	Epoch number in MergeLog table
Total length		350