Properties Values

All relations between properties and values are to be documented here (for a global change). Local changes (i.e. a constraint) can be defined in table classes_properties_values (see 8). Global change means that a value is assigned to or withdrawn from a property in any context, i.e. every class where the property is used. Local change (constraint) means that a value is only assigned to or withdrawn from a property in the context of a certain class.

Example 1: A BOOLEAN property always has the same value list in any context {true; false} for every property assigned to any class.

Example 2: A value list of {red, green, yellow} might be valid for a property “color of traffic lights” for a class “car traffic light”. But maybe it should be limited (“constrained”) for the property “color of traffic light” in the context of the class “pedestrian traffic light” to only {red, green}.

Each line is the relationship of one property to one value. If you would like to add x values to one property, you have to fill out x lines for each value with the same property identifier. The connection is related by either the id_pr_internal (if PR is new) or id_pr_existing (if PR is existing) of the property and either the id_va_internal (if VA is new) or id_va_existing (if VA is existing) of the value.

ADD PR_VA

ADD PR_VA = A VA (new or existing) shall be related to a property (new or existing).

Mandatory fields:

CR type ADD PR_VA
id_pr_internal or

id_pr_existing

in case of a new PR, insert the unique internal ID mentioned in table <properties>,

in case of an existing PR, it is the 6-digit identifier

code optional field, if value is coded
preferred name PR The PR´s name
id_va_internal or

id_va_existing

in case of a new VA, insert the unique internal ID mentioned in table <values>,

in case of an existing VA, it is the 6-digit identifier

preferred name VA the VA’s name
CR Proposer Your name
Reason for request Your reason for the change

NOTE: In case of ADD PR_VA the system has to check in database if assignment already exists and announce error on duplication. Duplications will be checked via Value ID and not by the preferred name of the VA.

UNASS PR_VA

UNASS PR_VA = The existing relation between a PR and a VA shall be deleted

Mandatory fields:

CR type UNASS PR_VA
id_pr_existing the 6-digit identifier mentioned in table <properties>
preferred name PR The PR´s name
preferred name PR the 6-digit identifier mentioned in table <values>
preferred name VA the VA’s name
CR Proposer Your name
Reason for request Your reason for the change