| Database Table StandardVersionDistribution |
[This is preliminary documentation and is subject to change.]
N:M relation between StandardVersion and OrgUnit.
Each row in this table corresponds to a distribution of one standard edition to an organizational unit.
When the organizational unit is an institution, this is called primary distribution.
When the organizational unit is a subunit below an institution, this is called secondary distribution.
FieldsField name | Type | Note | Description |
|---|---|---|---|
OrgUnitType | VARCHAR (20) | Primary key | Partial foreign key to OrgUnit that takes part in the distribution |
OrgUnitCode | VARCHAR (20) | Primary key | Partial foreign key to OrgUnit that takes part in the distribution |
StandardCode | VARCHAR (20) | Primary key | Partial foreign key to StandardVersion that takes part in the distribution |
VersionNumber | INT | Primary key | Partial foreign key to StandardVersion that takes part in the distribution |
Accepted | BIT | Whether or not the distribution is accepted - NB: not used! |
RelationsTable | Fields | Comment |
|---|---|---|
OrgUnitType, OrgUnitCode | The institution or subunit, to which a standard edition is distributed. | |
StandardCode, VersionNumber | The standard edition, that is distributed to an organizational unit. |