TABLE calSourceXSynopticSourceBestMatch

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

Required constraints:
Primary key is (sourceID,synFrameSetID)
(sourceID) references calSource(sourceID)
(synFrameSetID,synSeqNum) references calSynopticSource(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 calSource 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 calSource variability.	-0.9999995e9
flag	tinyint	1		Flag for potential matching problems	0
Total length		29