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