NF2.1 Composite Keys
Feature: Parent Composite Keys
Previously, in order to create a composite key you needed to define all composite columns as parent, but that didn't work properly. Now you can define composite keys in a table directly from the "Table Index" tab.
There are three flags related to the constraint creation:
- Create Constraint: Defines if a constraint is created on the table based on the defined index
- Unique: This is a unique constraint
- Key column: This is a primary key constraint
If you define multiple columns for the index then your constraint is composite.
This is now REQUIRED for translation tables.
Technical Info: IDEMPIERE-1901