In an example data model, I've created the relationships Transactions -> TranRules and Transaction -> TYPE_TRAN using TDM (Toad Data Modeler). Note the "Extra" PFK columns in the display. Now looking at Test3.dm2, which was re-engineered from the existing database (SQL2005) that already has these relationships established. TEST3.DM2 is correct and TEST2.DM2 is wrong.
Do not create PK in child tables manually, let the tool create them for you (TDM adds foreign keys or primary keys to parent / child tables automatically. It has advantages, e.g. when you change your PK in parent table, appropriate attributes will be modified in child tables automatically, if you remove PK attribute from parent table then appropriate FK attributes will be removed from child tables and so on.)
If someone really needs to link PK in parent table to existing attribute in child table then he/she must use the Foreign Keys Mapping feature
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center