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)