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

Total length 276

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
Total length		276