Values Constraint

NOTE: All relations between properties and values have to be documented in the table properties_values. They are global changes, i.e. the relation is valid in whichever context the property is used. The Constraint-function gives you the possibility to make a local change. Global change means that a value is assigned to or withdrawn from a property in any context, i.e. 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. A constraint cannot be applied to a BOOLEAN property, as the value list cannot be limited.

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 for one class. If you would like to limit values of a property in a specific class, you have to fill out x lines for each value with the same property identifier and the same class identifier. If you would like to activate a value that was once constrained, you have to fill out x lines for each value with the same property identifier and the same class identifier. The connection is related by either the id_class_non-existing (if class is new) or id_class_existing (if class is existing) of the class and either the id_pr_non-existing (if PR is new) or id_pr_existing (if PR is existing) of the property and either the id_va_non-existing (if VA is new) or id_va_existing (if VA is existing) of the value.

NOTE: All relations between properties and values have to be documented in the table properties_values first. If a relation was not defined in that table, then no constraint can be defined either. In this case every value of the used existing property will be shown. A constraint can only be placed on an existing relation that is documented in table properties_values.

ENABLE VA

ENABLE VA = A VA (new or existing) shall be related to a PR (new or existing) in the context of a certain Class (new or existing).

Mandatory fields:

CR type	ENABLE VA
id_class_non-existing or id_class_existing	in case of a new CC, insert the unique internal ID mentioned in table classes or the 8-digit CR ID in case of an existing CC, it is the 6-digit identifier
class coded name	8-digit ECLASS identifier
preferred name class	the CC’s name
id_pr_non-existing or id_pr_existing	in case of a new PR, insert the unique internal ID mentioned in table properties or the 8-digit CR ID in case of an existing PR, it is the 6-digit identifier
preferred name PR	the PR’s name
id_va_non-existing or id_va_existing	in case of a new VA, insert the unique internal ID mentioned in table values or the 8-digit CR ID in case of an existing VA, it is the 6-digit identifier
preferred name VA	the VA’s name
CR Proposer	CDP user name
Reason for request	Your reason for the change

DISABLE VA

DISABLE VA = The existing relation between a CC, a PR and a VA shall be deleted

Mandatory fields:

CR type	DISABLE VA
id_class_existing	the 6-digit identifier mentioned in table classes
class coded name	8-digit ECLASS identifier
preferred name class	the CC’s name
id_pr_existing	the 6-digit identifier mentioned in table properties
preferred name PR	the PR’s name
id_va_existing	the 6-digit identifier mentioned in table values
preferred name VA	the VA’s name
CR Proposer	CDP user name
Reason for request	Your reason for the change

NOTE: The EXCEL Sheet provides the possibility to choose between ENABLE and DISABLE VA. In case only a few values of a long value list are valid for a certain class, then it is easier to name only those values that shall be valid, i.e. ENABLED. Then please fill out one line ENABLE VA for each value that is valid. This is the preferred change request type as you most certainly know better the valid values.

Example 1: ENABLE VA

Class “pedestrian traffic light” (CC01)

Property “colour” (PR01)

Value list {red (VA01), yellow (VA02), green (VA03), blue (VA04), pink (VA05), white (VA06), brown (VA07)}

Red and green shall be the only valid values.

Two ENABLE VA change requests are necessary:

ENABLE VA CC01 PR01 VA01

ENABLE VA CC01 PR01 VA03

In case most of the values of a long value list are valid for a certain class, then it might be easier to name only those that shall be invalid, i.e. DISABLED. Then please fill out one line DISABLE VA for each value that is invalid. The database knows only ENABLE VA and will automatically create ENABLE VA for all values that are not listed with a DISABLE VA line.

Example 2: DISABLE VA

Class “light bulb” (CC02)

Property “colour” (PR01)

Value list {red (VA01), yellow (VA02), green (VA03), blue (VA04), pink (VA05), white (VA06), brown (VA07)}

Brown shall be the only invalid values

One DISABLE VA change request is necessary:

DISABLE VA CC02 PR01 VA07

(The database will automatically create ENABLE VA-change requests for all other values.)