TABLE  vmcdeepSourceXSynopticSourceBestMatch

Links each unique source in vmcdeepSource to each band-merged epoch in vmcdeepSynopticSource

Epochs may include a measurement (synSeqNum>0), but will still be linked
to epochs without measurements (synSeqNum==-99999999) if the frame overlaps
the source position. Within each epoch each filter may or may not
have an observation and may or may not have a measurement.

Required constraints:
  • Primary key is (sourceID,synFrameSetID)
  • (sourceID) references vmcdeepSource(sourceID)
  • (synFrameSetID,synSeqNum) references vmcdeepSynopticSource(synFrameSetID,synSeqNum)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
synFrameSetIDbigint8 the UID of the relevant frame set meta.id;obs.field
cuEventIDint4 UID of curation event giving rise to this record meta.id
synSeqNum tooltipint4 the running number of this source {catalogue TType keyword: Sequence_number} meta.id
modelDistSecsreal4arcsecseparation from expected position given astrometric model in vmcdeepSource variability.-0.9999995e9pos.posAng
flag link to glossaryint4 Flag for potential matching problems0meta.code.qual
Total length32