TABLE wserv1SourceXSynopticSourceBestMatch

Links each unique source in wserv1Source to each band-merged epoch in wserv1SynopticSource

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

Name Type Length Unit Description Default Value Unified Content Descriptor

sourceID bigint 8 UID (unique over entire WSA via programme ID prefix) of this merged detection as assigned by merge algorithm ID_MAIN

synFrameSetID bigint 8 the UID of the relevant frame set ID_FRAME

cuEventID int 4 UID of curation event giving rise to this record REFER_CODE

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

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

flag link to glossary tinyint 1 Flag for potential matching problems 0

Total length 29

Name	Type	Length	Unit	Description	Default Value	Unified Content Descriptor
sourceID	bigint	8		UID (unique over entire WSA via programme ID prefix) of this merged detection as assigned by merge algorithm		ID_MAIN
synFrameSetID	bigint	8		the UID of the relevant frame set		ID_FRAME
cuEventID	int	4		UID of curation event giving rise to this record		REFER_CODE
synSeqNum	int	4		the running number of this source {catalogue TType keyword: Sequence_number}		ID_NUMBER
modelDistSecs	real	4	arcsec	separation from expected position given astrometric model in wserv1Source variability.	-0.9999995e9
flag	tinyint	1		Flag for potential matching problems	0
Total length		29