Updates to SCV Constraint definitions
The configuration screen for SCV Constraints has been updated with these conditions for a better alignment with different constraint types:
- One of the active keys such as Primary Key (PK), Business Key (BK), Export Key (EK), Refresh Key (RK) or Hash Key (HK) can be defined on each SCV table. A defined PK, BK, EK, RK or HK on a table is enabled and cannot be disabled.
- When defining a new constraint, the list field on constraint type now displays only the possible types (i.e. the constraint types for which no constraint has been defined yet)
- Multiple Foreign Keys (FK) can be defined on each SCV table and defined FKs can be disabled (behavior did not change)
Note: By default, this feature is enabled. No additional role or privilege is required to access
this feature.