Composite unique constraint

[gledson]

Hi Everyone!

Is it possible create a composite unique constraint when modeling a data model in EA?


If I have a table with the columns (id, code, year, description) and  I mark the unique checkbox to columns code and  year, the EA generates the DDL with two uniques constraints but I want only one composite unique constraint.


Somebody knows how to make it?


Thanks,


Gledson Rabelo

[hd]

Open the table Operations dialog and create an operation with stereotype <unique>.

On the Columns tab, add the columns to it.

Henk