TABLE u08bh9SourceXDetectionBestMatch

Links each unique source in u08bh9Source to each stack epoch in Multiframe (or u08bh9Detection).

Epochs may include a measurement (seqNum>0), but will still be linked
to epochs without measurements (seqNum==-99999999) if the frame overlaps
the source position.

Required constraints:
Primary key is (sourceID,multiframeID)
(sourceID) references u08bh9Source(sourceID)
(multiframeID,extNum,seqNum) references u08bh9DetectionRaw(multiframeID,extNum,seqNum)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

multiframeID bigint 8 the UID of the relevant multiframe ID_FRAME

extNum tinyint 1 the extension number of this frame NUMBER

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

seqNum tooltip int 4 the running number of this detection {catalogue TType keyword: Sequence_number} -99999999 ID_NUMBER

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

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

Total length 30

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
multiframeID	bigint	8		the UID of the relevant multiframe		ID_FRAME
extNum	tinyint	1		the extension number of this frame		NUMBER
cuEventID	int	4		UID of curation event giving rise to this record		REFER_CODE
seqNum	int	4		the running number of this detection {catalogue TType keyword: Sequence_number}	-99999999	ID_NUMBER
modelDistSecs	real	4	arcsec	separation from expected position given astrometric model in u08bh9Source variability.	-0.9999995e9
flag	tinyint	1		Flag for potential matching problems	0
Total length		30