Universally Unique Identifiers

Information

• Each data table 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. Therefore it is usually not necessary to explicitly reference this column.
• Sometimes it can be helpful to read out the value of a UUID column for precise identification or for comparison.
• 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.

• For further information on UUID columns, please click here.

Note

• All data tables in PLANTA project must dispose of 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)