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 meta.id
tableIDint4 the unique identifier for the programme table meta.id
surveyIDint4 the unique identifier for the survey meta.id
extTableIDint4 the unique table ID meta.id;meta.main
joinCriterionreal4degreesthe join criterion (search radius for matches) ??
neighbourTablevarchar256 the name of the neighbour join table meta.id;meta.dataset
extProgIDint4 the unique programme ID for second table if there are multiple programmes in the neighbour survey-99999999meta.id
Total length280