Reference & Data Model
Specification (good_type_spec, spec_category, spec_value)
Specifications are technical attributes of a material category; articles carry values for them, technical requirements check them.
Purpose
Section titled “Purpose”A Technical specification (good_type_spec) defines an attribute with data type and unit on a material category. Specification categories (spec_category) group attributes. The Specification value (spec_value) is the concrete value of an article for an attribute. All three are master data that feed spec matching in engineering.
Where in the app
Section titled “Where in the app”Stammdaten › Material-Katalog (Master data › Material catalog): on the material category the area „Technische Kategorie-Spezifikationen“ (technical category specifications) with „Spezifikation-Kategorie hinzufügen“ (Add specification category), „Technische Spezifikation hinzufügen“ (Add technical specification) and „Merkmal bearbeiten“ (Edit attribute); on the article „Technische Daten“ (technical data) with „Spezifikationswert hinzufügen“ (Add specification value). On the product a matrix of the values of all articles. See Guides › Material catalog.
Fields
Section titled “Fields”Technical specification (good_type_spec)
Section titled “Technical specification (good_type_spec)”| Field | Technical | Type | Required | Meaning | Notes |
|---|---|---|---|---|---|
| Title | name |
Text | yes | Name of the attribute | |
| Data type | data_type |
Selection | yes | „Text“, „Zahl“ (number), „Auswahl“ (selection), „Ja/Nein“ (yes/no) | fixed after creation |
| Unit | unit |
Text | only visible for „Zahl“ | Unit of the attribute | required in DB; stored empty for other types |
| Options | options |
Text | only for „Auswahl“ | Comma-separated allowed values | options can later only be added, not removed |
| Material category | good_type_id |
Reference | yes | Defining category | from the tree |
| Specification category | spec_category_id |
Reference | no | Group in the data sheet | without a group under „Allgemein“ (General) |
Specification category (spec_category)
Section titled “Specification category (spec_category)”One field Category name (name, required) and the material category (good_type_id, required).
Specification value (spec_value)
Section titled “Specification value (spec_value)”| Field | Technical | Type | Required | Meaning | Notes |
|---|---|---|---|---|---|
| Value | value |
per data type | yes | Number (single value or range from–to), text, selection from options, yes/no | unit is displayed from the specification |
| Article / Specification | good_variant_id / good_type_spec_id |
Reference | yes | Assignment |
Relations
Section titled “Relations”| Related to | Kind | Required | On archive | On delete |
|---|---|---|---|---|
| Specification → material category | belongs to | yes | – | deleted along |
| Specification → specification category | belongs to | no | – | reference cleared |
| Specification → specification value | has many | – | – | deleted along |
Specification ← specification requirement (technical_structure_spec_req) |
has many | – | – | reference kept without a rule (no delete action declared) |
| Specification category → material category | belongs to | yes | – | deleted along |
| Specification value → article | belongs to | yes | – | deleted along |
Rules & automation
Section titled “Rules & automation”- Inheritance: An article has all specifications of its material category and of all parent categories. The data sheet shows „Geerbt von“ (inherited from). The „Spezifikationsabdeckung“ (specification coverage) measures how many effective specifications have values.
- Spec matching (engineering): Requirements use the conditions =, ≥, ≤, „zwischen“ (between) and „einer von“ (one of). A numeric value satisfies a condition when its whole interval (single value or range) lies within the bounds. Text and selection compare exactly (text without leading/trailing whitespace). A missing or type-mismatched value yields „ungeprüft“ (unchecked), never „verletzt“ (violated). See Specification requirement.
- Master data character: A changed specification value immediately changes the matching result in all technical structures that use the article. Deleting a specification deletes all values of all articles for it. The fixed data type prevents existing values from becoming invalid.
See also
Section titled “See also”Material · Component requirement · Technical component · Guides › Technical structure