TABLE  u05ah18aSourceXDetectionBestMatch

Links each unique source in u05ah18aSource to each stack epoch in Multiframe (or u05ah18aDetection).

Epochs may include a measurement (seqNum>0), but will still be linked
to epochs without measurements (seqNum==-99999999) if the frame overlaps
the source position.

Required constraints:
  • Primary key is (sourceID,multiframeID)
  • (sourceID) references u05ah18aSource(sourceID)
  • (multiframeID,extNum,seqNum) references u05ah18aDetectionRaw(multiframeID,extNum,seqNum)n

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
sourceIDbigint8 UID (unique over entire WSA via programme ID prefix) of this merged detection as assigned by merge algorithm ID_MAIN
multiframeIDbigint8 the UID of the relevant multiframe ID_FRAME
extNumtinyint1 the extension number of this frame NUMBER
cuEventIDint4 UID of curation event giving rise to this record REFER_CODE
seqNum tooltipint4 the running number of this detection {catalogue TType keyword: Sequence_number}-99999999ID_NUMBER
modelDistSecsreal4arcsecseparation from expected position given astrometric model in u05ah18aSource variability.-0.9999995e9 
flag link to glossarytinyint1 Flag for potential matching problems0 
Total length30