transformation Class diagram -> DDL

[Martin32]

In class diagram I have two classes:
Book { title:string; author: Person; editor: Person }
Person {name:string }
and
associations:
Book.author -> "Person"
Book.editor -> "Person"

After transformation to DDL a received this tables:
Book ( (PK)bookID: integer;  (FK)PersonID:integer; title:string );
Person ( (PK) PersonID:integer; name:string)
and two same relations:
Book.PersonID -> Person.PersonID
Book.PersonID -> Person.PersonID

I lose author/editor information. What do I wrong?

[thomaskilian]

Enter "foreign key" in the Help search. Read the third section (DDL Transform...) to see an example.

[Martin32]

I have already seen it but there is not "double association" in this exmaple.

[thomaskilian]

I have already seen it but there is not "double association" in this exmaple.

Because the primary key is created automatically and of type INTEGER. Your relations ar of type Person. It's not possible to map the foreign INT-key to person. Ergo, you have to manually work on the translation.

[cnj_mike]

I'm using PK/FKs of type INT and I have the same problem.  I have two members of class Component as FK to class Item.  My intention is

CLASS Component
 FK container_id  (containerId=itemId)
 FK component_id (componentId=itemId)

but no joy.  Any way to transform the PIM to a DDL without having to write my own transform code?  Seems like a common need.

[thomaskilian]

Double FK does not work (yet). I hardly remember having read something that 6.5 will be able to deal with that...

[Paolo F Cantoni]

Double FK does not work (yet). I hardly remember having read something that 6.5 will be able to deal with that...

Sparxians,
Don't forget you'll need to support multiple foreign keys with overlapping columns...  That is, a given column in a table may participate in more than one foreign key simultaneously.

As reported elsewhere in this forum, other products have difficulty with this.

Paolo