TABLE vmcSourceXSynopticSourceBestMatch

Links each unique source in vmcSource to each band-merged epoch in vmcSynopticSource

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 vmcSource(sourceID)
(synFrameSetID,synSeqNum) references vmcSynopticSource(synFrameSetID,synSeqNum)n

Name Type Length Unit Description Default Value Unified Content Descriptor

sourceID bigint 8 UID (unique over entire VSA via programme ID prefix) of this merged detection as assigned by merge algorithm meta.id;meta.main

synFrameSetID bigint 8 the UID of the relevant frame set meta.id;obs.field

cuEventID int 4 UID of curation event giving rise to this record meta.id

synSeqNum tooltip int 4 the running number of this source {catalogue TType keyword: Sequence_number} meta.id

modelDistSecs real 4 arcsec separation from expected position given astrometric model in vmcSource variability. -0.9999995e9 pos.posAng

flag link to glossary int 4 Flag for potential matching problems 0 meta.code.qual

Total length 32

Name	Type	Length	Unit	Description	Default Value	Unified Content Descriptor
sourceID	bigint	8		UID (unique over entire VSA via programme ID prefix) of this merged detection as assigned by merge algorithm		meta.id;meta.main
synFrameSetID	bigint	8		the UID of the relevant frame set		meta.id;obs.field
cuEventID	int	4		UID of curation event giving rise to this record		meta.id
synSeqNum	int	4		the running number of this source {catalogue TType keyword: Sequence_number}		meta.id
modelDistSecs	real	4	arcsec	separation from expected position given astrometric model in vmcSource variability.	-0.9999995e9	pos.posAng
flag	int	4		Flag for potential matching problems	0	meta.code.qual
Total length		32