TABLE  vmcSynopticMergeLog

Required constraints: Primary key is (synFrameSetID) (ymfID,yeNum) references MultiframeDetector(multiframeID,extNum) (jmfID,jeNum) references MultiframeDetector(multiframeID,extNum)n (ksmfID,kseNum) references MultiframeDetector(multiframeID,extNum)n

Name	Type	Length	Unit	Description	Default Value	Unified Content Descriptor
synFrameSetID	bigint	8		frame set ID, unique over the whole VSA via programme ID prefix, assigned by merging procedure		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.distance;pos.cartesian.x
cy	float	8		unit vector of spherical co-ordinates		pos.distance;pos.cartesian.y
cz	float	8		unit vector of spherical co-ordinates		pos.distance;pos.cartesian.z
htmID	bigint	8		Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates		pos.eq
meanMjdObs	float	8	days	Mean modified julian date of frameset.	-0.9999995e9	time.epoch
ymfID	bigint	8		the UID of the relevant Y multiframe		obs.field
yeNum	tinyint	1		the extension number of this Y frame		meta.number
newYframe	tinyint	1		new/old flag (1/0) of this detector image		meta.code
jmfID	bigint	8		the UID of the relevant J multiframe		obs.field
jeNum	tinyint	1		the extension number of this J frame		meta.number
newJframe	tinyint	1		new/old flag (1/0) of this detector image		meta.code
ksmfID	bigint	8		the UID of the relevant Ks multiframe		obs.field
kseNum	tinyint	1		the extension number of this Ks frame		meta.number
newKsframe	tinyint	1		new/old flag (1/0) of this detector image		meta.code
mergeSwVersion	real	4		version number of the software used to merge the frames		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		104