NF2.1 Composite Keys

From iDempiere en
(Redirected from NF2.1 Parent Composite Keys)
Jump to navigation Jump to search

Feature: Parent Composite Keys

Goal: Technical

Description:

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.

01 CompositeKeys.png

Technical Info: IDEMPIERE-1901