Database Table SurveyStandardVersion

[This is preliminary documentation and is subject to change.]

This table implements N:M relation between Survey and StandardVersion - that is: which standard editions are being surveyed in a survey.

This might be called distribution of standard editions per survey - but do not confuse this with distribution of standard editions per organizationlan unit (institution or subunit below institution).

The distribution of standard editions per survey has nothing to do with with distribution of standard editions per insititution or subunit. Ths is, standard may be distributed in a survey, even if it is not distributed to the institution "owning" the survey - and vice versa.

Fields

Field Name

Type

Note

Description

SurveyId

INT

Primary key

Reference to Survey

StandardCode

VARCHAR(20)

Primary key

Reference to StandardVersion

VersionNumber

INT

Primary key

Reference to StandardVersion