Labordatenbank data structure

The Labordatenbank is based on the following data structure:

  • A customer has n contacts and n orders (n = 0, 1 oder mehrere).
  • An order belongs to only one customer, contains n samples and n reports.
  • A sample belongs to only one order, has one specification / testing schedule and n parameters.
  • A report belongs to only one order and has n samples.
  • A specification / testing schedule has n nominal values, each of which is valid for only one parameter.
  • A parameter appears in n samples, has n nominal values, and belongs to only one parameter group.
  • A parameter group contains n parameters.

The diagram is a simplified visualization of main data structure of the Labordatenbank.
Elements like employees, access rights, offers, bills, receipts, notes, e-mails. etc. were not included for the sake of simplicity.

Last change: 12.11.2025

General information

Reports

Report table editor

Interfaces

Kompetenzen

AI functions

Employees

Introductory phase

Query reports

Orders

Samples

Templates

Customers

Client zone (optional)

Assets

Offers

Invoices

Parameters

Calculating with parameters

Webservices

Transformationscode

Test plans / limit values / specifications

Documents control

Material

Questions and answers

Equipment

Trainings

8D-report

Others

PDF templates

Supplier evaluation

File management

Processes