Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - PhilPess

Pages: [1]
Uml Process / Can the proposed foreign key be overruled?
« on: May 29, 2015, 05:06:52 pm »
I have imported an OpenEdge (Progress) schema in EA v12 with ODBC. Now I'm creating different logical ERD models which correspond to the several functional modules in my back office application.
However I'm expieriencing problems when creating foreign keys. The primary keys of each table are also imported by the reverse engineering wizard. But I can only create foreign keys on the primary keys, which isn't correct in all cases. For example
Table A has a composite primary key of 3 fields and also has 2 generic columns, the functional meaning of the latter 2 depend on their given content.  In Table B there are 5 columns which should be used to compose the foreign key to table A. 3 Of the columns in TableB correspond to the columns in Table A (for example: TableA.LicenseId = TableB.LicenseId etc). The other 2 columns in Table B columns should be linked to the generic (non-primary key) columns in Table A. The column names of the corresponding columns don't match.
Now the foreign key dialog creates dummy columns with an asterix in Table A, and these columns can't be changed. I've a already tried several possible solutions like creating extra constraints, but nothing seems to work.
Probably there will be an easy solution for this common problem. Thanks in advance.  

Pages: [1]