Book a Demo

Author Topic: table foreign key does not auto migrate?  (Read 3310 times)

klong555

  • EA Novice
  • *
  • Posts: 8
  • Karma: +0/-0
    • View Profile
table foreign key does not auto migrate?
« on: March 10, 2006, 07:31:25 am »
I am new to UML and also EA.  I am developing a physical model using tables in a data diagram.  I expected the FK definition of an association to automatically migrate the FK (such as in ERWIN).  But it seems that you have to type the FK into the target table and then assoc source and target columns to define the target col as a FK.
Is there a way to automatically migrate a PK to a source table as the FK???
thanks,
KL

thomaskilian

  • Guest
Re: table foreign key does not auto migrate?
« Reply #1 on: March 10, 2006, 09:39:18 am »
RTFM. It's explained in quite detail...

klong555

  • EA Novice
  • *
  • Posts: 8
  • Karma: +0/-0
    • View Profile
Re: table foreign key does not auto migrate?
« Reply #2 on: March 10, 2006, 11:24:40 am »
Thomas - RTFM?  read the feature manual?   prior to posting, I did read the help topic for FK and tried to figure out how to do it.  From the help topic, it looks like you have to enter the field in both tables - source and target.  If there is a topic I am missing, please point the way.
thank you.  

thomaskilian

  • Guest
Re: table foreign key does not auto migrate?
« Reply #3 on: March 10, 2006, 12:22:39 pm »
KL,
EA is not ERWIN but a UML tool. In that respect you have to do some work manually which ERWIN would save you. BUT you can do more than that. Create two classes and add some arbitrary attributes. Draw an association between both. Now use Transform Current Package from the context menu in the project view. Choose the DLL transformation and watch what EA has produced.

Okay. The current DLL transformation is quite limited but you can modify it for your needs. Maybe you should play a bit around with that. If you get it right you can create your database model from your domain model with a mere push of a button (and a bit manual work ;)).