TABLE  vvvSynopticMergeLog

Contains details of the merged MultiframeDetector images for the VVV.


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

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
synFrameSetID link to glossarybigint8 frame set ID, unique over the whole VSA via programme ID prefix, assigned by merging procedure meta.id;obs.field
cuEventIDint4 UID of curation event giving rise to this record meta.bib
rafloat8degreesRight Ascension of field centre pos.eq.ra;meta.main
decfloat8degreesDeclination of field centre pos.eq.dec;meta.main
cxfloat8 unit vector of spherical co-ordinates pos.cartesian.x;pos.eq
cyfloat8 unit vector of spherical co-ordinates pos.cartesian.y;pos.eq
czfloat8 unit vector of spherical co-ordinates pos.cartesian.z;pos.eq
htmIDbigint8 Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates pos
meanMjdObsfloat8daysMean modified julian date of frameset.-0.9999995e9time.epoch
zmfIDbigint8 the UID of the relevant Z multiframe meta.id;obs.field
zeNumtinyint1 the extension number of this Z frame meta.number
newZframetinyint1 new/old flag (1/0) of this detector image meta.code
ymfIDbigint8 the UID of the relevant Y multiframe meta.id;obs.field
yeNumtinyint1 the extension number of this Y frame meta.number
newYframetinyint1 new/old flag (1/0) of this detector image meta.code
jmfIDbigint8 the UID of the relevant J multiframe meta.id;obs.field
jeNumtinyint1 the extension number of this J frame meta.number
newJframetinyint1 new/old flag (1/0) of this detector image meta.code
hmfIDbigint8 the UID of the relevant H multiframe meta.id;obs.field
heNumtinyint1 the extension number of this H frame meta.number
newHframetinyint1 new/old flag (1/0) of this detector image meta.code
ksmfIDbigint8 the UID of the relevant Ks multiframe meta.id;obs.field
kseNumtinyint1 the extension number of this Ks frame meta.number
newKsframetinyint1 new/old flag (1/0) of this detector image meta.code
mergeSwVersionreal4 version number of the software used to merge the frames meta.id;meta.software
newFrameSettinyint1 Flag used internally by curation applications meta.code
deprecatedtinyint1 frame set deprecation flag (1=deprecated) meta.code
Total length124