I am currently evaluating TDM 126.96.36.199 and hit the following problem:
I have 4 Tables: A (PK = AID), M (PK = AID,MID), F (PK = AID,FID) and FS. M and F reference A, FS references M and F, see attached screenshot to get a clearer picture.
The PK from A is inherited to M and F and forms a compound PK in M (PK = AID, MID) and F (PK = AID,FID). So far so good, but when I reference M and F from FS, the PK from A is inherited twice to FS. So the PK in FS is AID,MID,AID,FID but it should only by AID,MID,FID.
I tried to remove one of the AIDs in the Attribute or in the FS Key definitions, but no success. I know I can rename one of the AIDs in FS, but that is not the problem, I need to remove it.
Suprisingly, if I reverse engineer the tables from an Oracle DB, the model is created correctly.
Do you have any idea how to create such a model by hand?
Thanks in advance,