TABLE RequiredNeighbours

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

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

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 meta.id

tableID int 4 the unique identifier for the programme table meta.id

surveyID int 4 the unique identifier for the survey meta.id

extTableID int 4 the unique table ID meta.id;meta.main

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

neighbourTable varchar 256 the name of the neighbour join table meta.id;meta.dataset

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

Total length 280

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