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)