Attributes which are defined as key attributes can be changed manually. This way it is no longer guaranteed that they are really unique.
- A Unique index is not possible because it is too strict and a historization is not possible.
- Unique Index on multiple fields, e.g. the from_Date, To_Date fields,is not a solution either, because the date fields are not single values, they define time ranges.
How do you deal with it?