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)
(programmeID,tableID) references ProgrammeTable(programmeID,tableID)
(surveyID,extTableID) references ExternalSurveyTable(surveyID,extTableID)

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

joinType smallint 2 The type of join: 0 (default) or N for special join ??

Total length 278

Name	Type	Length	Unit	Description	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
joinType	smallint	2		The type of join: 0 (default) or N for special join	??
Total length		278