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.