Book a Demo

Author Topic: Composite unique in Data model  (Read 1987 times)

juancastellanosm

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Composite unique in Data model
« on: May 27, 2007, 08:15:02 am »
Hi

I need to know how I can create a composite unique in the data model.

Thanks

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: Composite unique in Data model
« Reply #1 on: May 27, 2007, 09:55:47 am »
Hi Juan,

Do this by creating a constraint that identifies the column and constrains them to be unique.

You will first create the columns normally, without setting the Unique check box. Then create the constraint via the Operations dialog. You will need to name the constraint and set the correct stereotype (when you open the Operations dialog for a Table EA will give you the appropriate list).

Once you've tried this the documentation will start making more sense.

David
No, you can't have it!

juancastellanosm

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Re: Composite unique in Data model
« Reply #2 on: May 27, 2007, 10:05:45 am »
That works.

Thanks