TABLE vvvMergeLog

Contains frame set details of merged VVV MultiframeDetector images.

Prescription for the merging (from RequiredFilters) is: Z, Z_1, Z_2, Y, Y_1, Y_2, J, J_1, J_2, H, H_1, H_2, Ks, Ks_1, Ks_2
Bandpass Z comes from deepest Z tile frame measurements.
Bandpass Z_1 comes from first OB epoch measurements. This epoch contains data from an Z.Y OB tile frame
Bandpass Z_2 comes from second OB epoch measurements. This epoch contains data from an Z.Y OB tile frame
Bandpass Y comes from deepest Y tile frame measurements.
Bandpass Y_1 comes from first OB epoch measurements. This epoch contains data from an Z.Y OB tile frame
Bandpass Y_2 comes from second OB epoch measurements. This epoch contains data from an Z.Y OB tile frame
Bandpass J comes from deepest J tile frame measurements.
Bandpass J_1 comes from first OB epoch measurements. This epoch contains data from an J.H.Ks OB tile frame
Bandpass J_2 comes from second OB epoch measurements. This epoch contains data from an J.H.Ks OB tile frame
Bandpass H comes from deepest H tile frame measurements.
Bandpass H_1 comes from first OB epoch measurements. This epoch contains data from an J.H.Ks OB tile frame
Bandpass H_2 comes from second OB epoch measurements. This epoch contains data from an J.H.Ks OB tile frame
Bandpass KS comes from deepest Ks tile frame measurements.
Bandpass KS_1 comes from first OB epoch measurements. This epoch contains data from an J.H.Ks OB tile frame
Bandpass KS_2 comes from second OB epoch measurements. This epoch contains data from an J.H.Ks OB tile frame

Required constraints:
Primary key is (frameSetID)
(zmfID,zeNum) references MultiframeDetector(multiframeID,extNum)
(z_1mfID,z_1eNum) references MultiframeDetector(multiframeID,extNum)n
(z_2mfID,z_2eNum) references MultiframeDetector(multiframeID,extNum)n
(ymfID,yeNum) references MultiframeDetector(multiframeID,extNum)n
(y_1mfID,y_1eNum) references MultiframeDetector(multiframeID,extNum)n
(y_2mfID,y_2eNum) references MultiframeDetector(multiframeID,extNum)n
(jmfID,jeNum) references MultiframeDetector(multiframeID,extNum)n
(j_1mfID,j_1eNum) references MultiframeDetector(multiframeID,extNum)n
(j_2mfID,j_2eNum) references MultiframeDetector(multiframeID,extNum)n
(hmfID,heNum) references MultiframeDetector(multiframeID,extNum)n
(h_1mfID,h_1eNum) references MultiframeDetector(multiframeID,extNum)n
(h_2mfID,h_2eNum) references MultiframeDetector(multiframeID,extNum)n
(ksmfID,kseNum) references MultiframeDetector(multiframeID,extNum)n
(ks_1mfID,ks_1eNum) references MultiframeDetector(multiframeID,extNum)n
(ks_2mfID,ks_2eNum) references MultiframeDetector(multiframeID,extNum)n

Name Type Length Unit Description Default Value Unified Content Descriptor

frameSetID link to glossary bigint 8 frame set ID, unique over the whole VSA via programme ID prefix, assigned by merging procedure meta.id;obs.field

cuEventID int 4 UID of curation event giving rise to this record meta.bib

ra float 8 degrees Right Ascension of field centre pos.eq.ra;meta.main

dec float 8 degrees Declination of field centre pos.eq.dec;meta.main

cx float 8 unit vector of spherical co-ordinates pos.cartesian.x;pos.eq

cy float 8 unit vector of spherical co-ordinates pos.cartesian.y;pos.eq

cz float 8 unit vector of spherical co-ordinates pos.cartesian.z;pos.eq

htmID bigint 8 Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates pos.HTM

zmfID bigint 8 the UID of the relevant Z multiframe meta.id;obs.field;em.opt.I

zeNum tinyint 1 the extension number of this Z frame meta.number;em.opt.I

newZframe tinyint 1 new/old flag (1/0) of this detector image meta.code;em.opt.I

listProcZ tinyint 1 Frame has been list processed (0=no; 1=yes) meta.code;em.opt.I

z_1mfID bigint 8 the UID of the relevant Z_1 multiframe meta.id;obs.field;em.opt.I

z_1eNum tinyint 1 the extension number of this Z_1 frame meta.number;em.opt.I

newZ_1frame tinyint 1 new/old flag (1/0) of this detector image meta.code;em.opt.I

listProcZ_1 tinyint 1 Frame has been list processed (0=no; 1=yes) meta.code;em.opt.I

z_2mfID bigint 8 the UID of the relevant Z_2 multiframe meta.id;obs.field;em.opt.I

z_2eNum tinyint 1 the extension number of this Z_2 frame meta.number;em.opt.I

newZ_2frame tinyint 1 new/old flag (1/0) of this detector image meta.code;em.opt.I

listProcZ_2 tinyint 1 Frame has been list processed (0=no; 1=yes) meta.code;em.opt.I

ymfID bigint 8 the UID of the relevant Y multiframe meta.id;obs.field;em.IR.NIR

yeNum tinyint 1 the extension number of this Y frame meta.number;em.IR.NIR

newYframe tinyint 1 new/old flag (1/0) of this detector image meta.code;em.IR.NIR

listProcY tinyint 1 Frame has been list processed (0=no; 1=yes) meta.code;em.IR.NIR

y_1mfID bigint 8 the UID of the relevant Y_1 multiframe meta.id;obs.field;em.IR.NIR

y_1eNum tinyint 1 the extension number of this Y_1 frame meta.number;em.IR.NIR

newY_1frame tinyint 1 new/old flag (1/0) of this detector image meta.code;em.IR.NIR

listProcY_1 tinyint 1 Frame has been list processed (0=no; 1=yes) meta.code;em.IR.NIR

y_2mfID bigint 8 the UID of the relevant Y_2 multiframe meta.id;obs.field;em.IR.NIR

y_2eNum tinyint 1 the extension number of this Y_2 frame meta.number;em.IR.NIR

newY_2frame tinyint 1 new/old flag (1/0) of this detector image meta.code;em.IR.NIR

listProcY_2 tinyint 1 Frame has been list processed (0=no; 1=yes) meta.code;em.IR.NIR

jmfID bigint 8 the UID of the relevant J multiframe meta.id;obs.field;em.IR.J

jeNum tinyint 1 the extension number of this J frame meta.number;em.IR.J

newJframe tinyint 1 new/old flag (1/0) of this detector image meta.code;em.IR.J

listProcJ tinyint 1 Frame has been list processed (0=no; 1=yes) meta.code;em.IR.J

j_1mfID bigint 8 the UID of the relevant J_1 multiframe meta.id;obs.field;em.IR.J

j_1eNum tinyint 1 the extension number of this J_1 frame meta.number;em.IR.J

newJ_1frame tinyint 1 new/old flag (1/0) of this detector image meta.code;em.IR.J

listProcJ_1 tinyint 1 Frame has been list processed (0=no; 1=yes) meta.code;em.IR.J

j_2mfID bigint 8 the UID of the relevant J_2 multiframe meta.id;obs.field;em.IR.J

j_2eNum tinyint 1 the extension number of this J_2 frame meta.number;em.IR.J

newJ_2frame tinyint 1 new/old flag (1/0) of this detector image meta.code;em.IR.J

listProcJ_2 tinyint 1 Frame has been list processed (0=no; 1=yes) meta.code;em.IR.J

hmfID bigint 8 the UID of the relevant H multiframe meta.id;obs.field;em.IR.H

heNum tinyint 1 the extension number of this H frame meta.number;em.IR.H

newHframe tinyint 1 new/old flag (1/0) of this detector image meta.code;em.IR.H

listProcH tinyint 1 Frame has been list processed (0=no; 1=yes) meta.code;em.IR.H

h_1mfID bigint 8 the UID of the relevant H_1 multiframe meta.id;obs.field;em.IR.H

h_1eNum tinyint 1 the extension number of this H_1 frame meta.number;em.IR.H

newH_1frame tinyint 1 new/old flag (1/0) of this detector image meta.code;em.IR.H

listProcH_1 tinyint 1 Frame has been list processed (0=no; 1=yes) meta.code;em.IR.H

h_2mfID bigint 8 the UID of the relevant H_2 multiframe meta.id;obs.field;em.IR.H

h_2eNum tinyint 1 the extension number of this H_2 frame meta.number;em.IR.H

newH_2frame tinyint 1 new/old flag (1/0) of this detector image meta.code;em.IR.H

listProcH_2 tinyint 1 Frame has been list processed (0=no; 1=yes) meta.code;em.IR.H

ksmfID bigint 8 the UID of the relevant Ks multiframe meta.id;obs.field;em.IR.K

kseNum tinyint 1 the extension number of this Ks frame meta.number;em.IR.K

newKsframe tinyint 1 new/old flag (1/0) of this detector image meta.code;em.IR.K

listProcKs tinyint 1 Frame has been list processed (0=no; 1=yes) meta.code;em.IR.K

ks_1mfID bigint 8 the UID of the relevant Ks_1 multiframe meta.id;obs.field;em.IR.K

ks_1eNum tinyint 1 the extension number of this Ks_1 frame meta.number;em.IR.K

newKs_1frame tinyint 1 new/old flag (1/0) of this detector image meta.code;em.IR.K

listProcKs_1 tinyint 1 Frame has been list processed (0=no; 1=yes) meta.code;em.IR.K

ks_2mfID bigint 8 the UID of the relevant Ks_2 multiframe meta.id;obs.field;em.IR.K

ks_2eNum tinyint 1 the extension number of this Ks_2 frame meta.number;em.IR.K

newKs_2frame tinyint 1 new/old flag (1/0) of this detector image meta.code;em.IR.K

listProcKs_2 tinyint 1 Frame has been list processed (0=no; 1=yes) meta.code;em.IR.K

mergeSwVersion real 4 version number of the software used to merge the frames meta.id;meta.software

newFrameSet tinyint 1 Flag used internally by curation applications meta.code

deprecated tinyint 1 frame set deprecation flag (1=deprecated) meta.code

Total length 231

Name	Type	Length	Unit	Description	Unified Content Descriptor
frameSetID	bigint	8		frame set ID, unique over the whole VSA via programme ID prefix, assigned by merging procedure	meta.id;obs.field
cuEventID	int	4		UID of curation event giving rise to this record	meta.bib
ra	float	8	degrees	Right Ascension of field centre	pos.eq.ra;meta.main
dec	float	8	degrees	Declination of field centre	pos.eq.dec;meta.main
cx	float	8		unit vector of spherical co-ordinates	pos.cartesian.x;pos.eq
cy	float	8		unit vector of spherical co-ordinates	pos.cartesian.y;pos.eq
cz	float	8		unit vector of spherical co-ordinates	pos.cartesian.z;pos.eq
htmID	bigint	8		Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates	pos.HTM
zmfID	bigint	8		the UID of the relevant Z multiframe	meta.id;obs.field;em.opt.I
zeNum	tinyint	1		the extension number of this Z frame	meta.number;em.opt.I
newZframe	tinyint	1		new/old flag (1/0) of this detector image	meta.code;em.opt.I
listProcZ	tinyint	1		Frame has been list processed (0=no; 1=yes)	meta.code;em.opt.I
z_1mfID	bigint	8		the UID of the relevant Z_1 multiframe	meta.id;obs.field;em.opt.I
z_1eNum	tinyint	1		the extension number of this Z_1 frame	meta.number;em.opt.I
newZ_1frame	tinyint	1		new/old flag (1/0) of this detector image	meta.code;em.opt.I
listProcZ_1	tinyint	1		Frame has been list processed (0=no; 1=yes)	meta.code;em.opt.I
z_2mfID	bigint	8		the UID of the relevant Z_2 multiframe	meta.id;obs.field;em.opt.I
z_2eNum	tinyint	1		the extension number of this Z_2 frame	meta.number;em.opt.I
newZ_2frame	tinyint	1		new/old flag (1/0) of this detector image	meta.code;em.opt.I
listProcZ_2	tinyint	1		Frame has been list processed (0=no; 1=yes)	meta.code;em.opt.I
ymfID	bigint	8		the UID of the relevant Y multiframe	meta.id;obs.field;em.IR.NIR
yeNum	tinyint	1		the extension number of this Y frame	meta.number;em.IR.NIR
newYframe	tinyint	1		new/old flag (1/0) of this detector image	meta.code;em.IR.NIR
listProcY	tinyint	1		Frame has been list processed (0=no; 1=yes)	meta.code;em.IR.NIR
y_1mfID	bigint	8		the UID of the relevant Y_1 multiframe	meta.id;obs.field;em.IR.NIR
y_1eNum	tinyint	1		the extension number of this Y_1 frame	meta.number;em.IR.NIR
newY_1frame	tinyint	1		new/old flag (1/0) of this detector image	meta.code;em.IR.NIR
listProcY_1	tinyint	1		Frame has been list processed (0=no; 1=yes)	meta.code;em.IR.NIR
y_2mfID	bigint	8		the UID of the relevant Y_2 multiframe	meta.id;obs.field;em.IR.NIR
y_2eNum	tinyint	1		the extension number of this Y_2 frame	meta.number;em.IR.NIR
newY_2frame	tinyint	1		new/old flag (1/0) of this detector image	meta.code;em.IR.NIR
listProcY_2	tinyint	1		Frame has been list processed (0=no; 1=yes)	meta.code;em.IR.NIR
jmfID	bigint	8		the UID of the relevant J multiframe	meta.id;obs.field;em.IR.J
jeNum	tinyint	1		the extension number of this J frame	meta.number;em.IR.J
newJframe	tinyint	1		new/old flag (1/0) of this detector image	meta.code;em.IR.J
listProcJ	tinyint	1		Frame has been list processed (0=no; 1=yes)	meta.code;em.IR.J
j_1mfID	bigint	8		the UID of the relevant J_1 multiframe	meta.id;obs.field;em.IR.J
j_1eNum	tinyint	1		the extension number of this J_1 frame	meta.number;em.IR.J
newJ_1frame	tinyint	1		new/old flag (1/0) of this detector image	meta.code;em.IR.J
listProcJ_1	tinyint	1		Frame has been list processed (0=no; 1=yes)	meta.code;em.IR.J
j_2mfID	bigint	8		the UID of the relevant J_2 multiframe	meta.id;obs.field;em.IR.J
j_2eNum	tinyint	1		the extension number of this J_2 frame	meta.number;em.IR.J
newJ_2frame	tinyint	1		new/old flag (1/0) of this detector image	meta.code;em.IR.J
listProcJ_2	tinyint	1		Frame has been list processed (0=no; 1=yes)	meta.code;em.IR.J
hmfID	bigint	8		the UID of the relevant H multiframe	meta.id;obs.field;em.IR.H
heNum	tinyint	1		the extension number of this H frame	meta.number;em.IR.H
newHframe	tinyint	1		new/old flag (1/0) of this detector image	meta.code;em.IR.H
listProcH	tinyint	1		Frame has been list processed (0=no; 1=yes)	meta.code;em.IR.H
h_1mfID	bigint	8		the UID of the relevant H_1 multiframe	meta.id;obs.field;em.IR.H
h_1eNum	tinyint	1		the extension number of this H_1 frame	meta.number;em.IR.H
newH_1frame	tinyint	1		new/old flag (1/0) of this detector image	meta.code;em.IR.H
listProcH_1	tinyint	1		Frame has been list processed (0=no; 1=yes)	meta.code;em.IR.H
h_2mfID	bigint	8		the UID of the relevant H_2 multiframe	meta.id;obs.field;em.IR.H
h_2eNum	tinyint	1		the extension number of this H_2 frame	meta.number;em.IR.H
newH_2frame	tinyint	1		new/old flag (1/0) of this detector image	meta.code;em.IR.H
listProcH_2	tinyint	1		Frame has been list processed (0=no; 1=yes)	meta.code;em.IR.H
ksmfID	bigint	8		the UID of the relevant Ks multiframe	meta.id;obs.field;em.IR.K
kseNum	tinyint	1		the extension number of this Ks frame	meta.number;em.IR.K
newKsframe	tinyint	1		new/old flag (1/0) of this detector image	meta.code;em.IR.K
listProcKs	tinyint	1		Frame has been list processed (0=no; 1=yes)	meta.code;em.IR.K
ks_1mfID	bigint	8		the UID of the relevant Ks_1 multiframe	meta.id;obs.field;em.IR.K
ks_1eNum	tinyint	1		the extension number of this Ks_1 frame	meta.number;em.IR.K
newKs_1frame	tinyint	1		new/old flag (1/0) of this detector image	meta.code;em.IR.K
listProcKs_1	tinyint	1		Frame has been list processed (0=no; 1=yes)	meta.code;em.IR.K
ks_2mfID	bigint	8		the UID of the relevant Ks_2 multiframe	meta.id;obs.field;em.IR.K
ks_2eNum	tinyint	1		the extension number of this Ks_2 frame	meta.number;em.IR.K
newKs_2frame	tinyint	1		new/old flag (1/0) of this detector image	meta.code;em.IR.K
listProcKs_2	tinyint	1		Frame has been list processed (0=no; 1=yes)	meta.code;em.IR.K
mergeSwVersion	real	4		version number of the software used to merge the frames	meta.id;meta.software
newFrameSet	tinyint	1		Flag used internally by curation applications	meta.code
deprecated	tinyint	1		frame set deprecation flag (1=deprecated)	meta.code
Total length		231