TABLE  RequiredNeighbours

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

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

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

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
programmeIDint4 the unique programme ID
tableIDint4 the unique identifier for the programme table
surveyIDint4 the unique identifier for the survey
extTableIDint4 the unique table ID;meta.main
joinCriterionreal4degreesthe join criterion (search radius for matches) ??
neighbourTablevarchar256 the name of the neighbour join table;meta.dataset
extProgIDint4 the unique programme ID for second table if there are multiple programmes in the neighbour
Total length280