TABLE  vvvSourceXDetectionBestMatch

Links each unique source to the best set of possible detections.


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

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