TABLE  calMergeLog

Contains frame set details of merged CAL MultiframeDetector images.

Prescription for the merging (from RequiredFilters) is: Z, Y, J, H, K, H2, Br, Nbj
Bandpass Z comes from deepest Z stack frame measurements.
Bandpass Y comes from deepest Y stack frame measurements.
Bandpass J comes from deepest J stack frame measurements.
Bandpass H comes from deepest H stack frame measurements.
Bandpass K comes from deepest K stack frame measurements.
Bandpass H2 comes from deepest H2 stack frame measurements.
Bandpass BR comes from deepest Br stack frame measurements.
Bandpass NBJ comes from deepest NBJ stack frame measurements.

Required constraints:
  • Primary key is (frameSetID)
  • (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
frameSetID 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
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
listProcZtinyint1 Frame has been list processed (0=no; 1=yes) 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
listProcYtinyint1 Frame has been list processed (0=no; 1=yes) 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
listProcJtinyint1 Frame has been list processed (0=no; 1=yes) 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
listProcHtinyint1 Frame has been list processed (0=no; 1=yes) 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
listProcKtinyint1 Frame has been list processed (0=no; 1=yes) 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
listProcH2tinyint1 Frame has been list processed (0=no; 1=yes) 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
listProcBrtinyint1 Frame has been list processed (0=no; 1=yes) 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
listProcNbjtinyint1 Frame has been list processed (0=no; 1=yes) 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