TABLE RequiredNeighbours

Details programmes/survey tables that have default joins within the WSA.

This table contains the matrix of programmes/external survey tables that
have default neighbour joins within the WSA.

Required constraints:
Primary key is (programmeID,tableID,surveyID,extTableID,extProgID)
(programmeID,tableID) references ProgrammeTable(programmeID,tableID)

Name Type Length Unit Description Default Value Unified Content Descriptor

programmeID int 4 the unique programme ID ID_SURVEY

tableID int 4 the unique identifier for the programme table ID_SURVEY

surveyID int 4 the unique identifier for the survey ID_SURVEY

extTableID int 4 the unique table ID ID_MAIN

joinCriterion real 4 arcminutes the join criterion (search radius for matches) ??

neighbourTable varchar 256 the name of the neighbour join table ID_TABLE

extProgID int 4 the unique programme ID for second table if there are multiple programmes in the neighbour survey -99999999 ID_SURVEY

Total length 280

Name	Type	Length	Unit	Description	Default Value	Unified Content Descriptor
programmeID	int	4		the unique programme ID		ID_SURVEY
tableID	int	4		the unique identifier for the programme table		ID_SURVEY
surveyID	int	4		the unique identifier for the survey		ID_SURVEY
extTableID	int	4		the unique table ID		ID_MAIN
joinCriterion	real	4	arcminutes	the join criterion (search radius for matches)		??
neighbourTable	varchar	256		the name of the neighbour join table		ID_TABLE
extProgID	int	4		the unique programme ID for second table if there are multiple programmes in the neighbour survey	-99999999	ID_SURVEY
Total length		280