Modeling Database Constraints

[CookingFat]

Hi,

I wonder if some kind soul would offer a word of advice to a newbie EA user.

I'm modeling a new database and one of the tables has several fields that I want to add a constraint to so it ensures that a group of fields is always unique.

Can I model this through EA or do I have to manually add the Unique Constraint?

Regards
Paul

[Bruno.Cossi]

Hi Paul,

open the table's properties, go to the tab Table Detail and click on Operations. Add a new operation and choose for it the stereotype Unique. Save the operation and click on the tab Columns. Here you can select the columns that make up your unique constraint.

Hope this helps!

Bruno

[CookingFat]

Works a treat.  Thank you.


Regards
Paul

[Bruno.Cossi]

No problem!

Bruno