TABLE  vphasMergeLog

Contains frame set details of merged VPHAS MultiframeDetector images.

Prescription for the merging (from RequiredFilters) is: U, G, R_1, R_2, I, Havphas
Bandpass U comes from single epoch OB u normal frame measurements.
Bandpass G comes from single epoch OB g normal frame measurements.
Bandpass R_1 comes from single epoch OB r_1 normal frame measurements.
Bandpass R_2 comes from single epoch OB r_2 normal frame measurements.
Bandpass I comes from single epoch OB i normal frame measurements.
Bandpass HAVPHAS comes from single epoch OB HaVPHAS normal frame measurements.

Required constraints:
  • Primary key is (frameSetID)
  • (umfID,ueNum) references MultiframeDetector(multiframeID,extNum)
  • (gmfID,geNum) references MultiframeDetector(multiframeID,extNum)n
  • (r_1mfID,r_1eNum) references MultiframeDetector(multiframeID,extNum)n
  • (r_2mfID,r_2eNum) references MultiframeDetector(multiframeID,extNum)n
  • (imfID,ieNum) references MultiframeDetector(multiframeID,extNum)n
  • (havphasmfID,havphaseNum) references MultiframeDetector(multiframeID,extNum)n

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
frameSetID link to glossarybigint8 frame set ID, unique over the whole OSA 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
umfIDbigint8 the UID of the relevant U multiframe meta.id;obs.field;em.opt.U
ueNumtinyint1 the extension number of this U frame meta.number;em.opt.U
newUframetinyint1 new/old flag (1/0) of this detector image meta.code;em.opt.U
listProcUtinyint1 Frame has been list processed (0=no; 1=yes) meta.code;em.opt.U
gmfIDbigint8 the UID of the relevant G multiframe meta.id;obs.field;em.opt.B
geNumtinyint1 the extension number of this G frame meta.number;em.opt.B
newGframetinyint1 new/old flag (1/0) of this detector image meta.code;em.opt.B
listProcGtinyint1 Frame has been list processed (0=no; 1=yes) meta.code;em.opt.B
r_1mfIDbigint8 the UID of the relevant R_1 multiframe meta.id;obs.field
r_1eNumtinyint1 the extension number of this R_1 frame meta.number
newR_1frametinyint1 new/old flag (1/0) of this detector image meta.code
listProcR_1tinyint1 Frame has been list processed (0=no; 1=yes) meta.code
r_2mfIDbigint8 the UID of the relevant R_2 multiframe meta.id;obs.field
r_2eNumtinyint1 the extension number of this R_2 frame meta.number
newR_2frametinyint1 new/old flag (1/0) of this detector image meta.code
listProcR_2tinyint1 Frame has been list processed (0=no; 1=yes) meta.code
imfIDbigint8 the UID of the relevant I multiframe meta.id;obs.field;em.opt.I
ieNumtinyint1 the extension number of this I frame meta.number;em.opt.I
newIframetinyint1 new/old flag (1/0) of this detector image meta.code;em.opt.I
listProcItinyint1 Frame has been list processed (0=no; 1=yes) meta.code;em.opt.I
havphasmfIDbigint8 the UID of the relevant Havphas multiframe meta.id;obs.field;em.opt.R;em.line.Halpha
havphaseNumtinyint1 the extension number of this Havphas frame meta.number;em.opt.R;em.line.Halpha
newHavphasframetinyint1 new/old flag (1/0) of this detector image meta.code;em.opt.R;em.line.Halpha
listProcHavphastinyint1 Frame has been list processed (0=no; 1=yes) meta.code;em.opt.R;em.line.Halpha
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 length132