TABLE  calSynopticMergeLog

Contains details of the merged MultiframeDetector images for the CAL.


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
  • (kmfID,keNum) references MultiframeDetector(multiframeID,extNum)n
  • (h2mfID,h2eNum) references MultiframeDetector(multiframeID,extNum)n
  • (brmfID,breNum) references MultiframeDetector(multiframeID,extNum)n
  • (nbjmfID,nbjeNum) references MultiframeDetector(multiframeID,extNum)n

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
synFrameSetID link to glossarybigint8 frame set ID, unique over the whole WSA via programme ID prefix, assigned by merging procedure ID_FIELD
cuEventIDint4 UID of curation event giving rise to this record REFER_CODE
rafloat8degreesRight Ascension of field centre POS_EQ_RA_MAIN
decfloat8degreesDeclination of field centre POS_EQ_DEC_MAIN
cxfloat8 unit vector of spherical co-ordinates POS_EQ_X
cyfloat8 unit vector of spherical co-ordinates POS_EQ_Y
czfloat8 unit vector of spherical co-ordinates POS_EQ_Z
htmIDbigint8 Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates POS_GENERAL
meanMjdObsfloat8daysMean modified julian date of frameset.-0.9999995e9TIME_DATE
zmfIDbigint8 the UID of the relevant Z multiframe ID_FRAME
zeNumtinyint1 the extension number of this Z frame NUMBER
newZframetinyint1 new/old flag (1/0) of this detector image CODE_MISC
ymfIDbigint8 the UID of the relevant Y multiframe ID_FRAME
yeNumtinyint1 the extension number of this Y frame NUMBER
newYframetinyint1 new/old flag (1/0) of this detector image CODE_MISC
jmfIDbigint8 the UID of the relevant J multiframe ID_FRAME
jeNumtinyint1 the extension number of this J frame NUMBER
newJframetinyint1 new/old flag (1/0) of this detector image CODE_MISC
hmfIDbigint8 the UID of the relevant H multiframe ID_FRAME
heNumtinyint1 the extension number of this H frame NUMBER
newHframetinyint1 new/old flag (1/0) of this detector image CODE_MISC
kmfIDbigint8 the UID of the relevant K multiframe ID_FRAME
keNumtinyint1 the extension number of this K frame NUMBER
newKframetinyint1 new/old flag (1/0) of this detector image CODE_MISC
h2mfIDbigint8 the UID of the relevant H2 multiframe ID_FRAME
h2eNumtinyint1 the extension number of this H2 frame NUMBER
newH2frametinyint1 new/old flag (1/0) of this detector image CODE_MISC
brmfIDbigint8 the UID of the relevant Br multiframe ID_FRAME
breNumtinyint1 the extension number of this Br frame NUMBER
newBrframetinyint1 new/old flag (1/0) of this detector image CODE_MISC
nbjmfIDbigint8 the UID of the relevant Nbj multiframe ID_FRAME
nbjeNumtinyint1 the extension number of this Nbj frame NUMBER
newNbjframetinyint1 new/old flag (1/0) of this detector image CODE_MISC
mergeSwVersionreal4 version number of the software used to merge the frames ID_VERSION
newFrameSettinyint1 Flag used internally by curation applications CODE_MISC
deprecatedtinyint1 frame set deprecation flag (1=deprecated) CODE_MISC
Total length154