Universally Unique Identifiers

Information

• Each table of the Q1 and Q2 database schemas has a column named UUID of the Universally Unique Identifier type (short: UUID).

  • These columns serve to uniquely identify records.

  • At runtime, it is automatically filled with a unique value. It is therefore usually not necessary to reference this column explicitly.

• Sometimes it can be helpful to read out the value of a UUID column for precise identification or for comparison.

Caution

• We strongly advise you against giving write access to any (explicit) UUID field (also via SQL scripts, etc.).

• The manual manipulation/overwriting of (existing) UUID columns is highly critical and may lead to data inconsistency or cause the records not to be found any longer.

Notes

• All data tables in PLANTA project must have UUIDs, otherwise the following functions cannot be used:

  • Web Interfaces

  • Relational deletion

  • HQL

  • Data Export and Data Import

  • Automatic IDs

  • Historization of data tables

  • Functions to come (see here)

For further information on UUID columns, please click here.