Modeling FKs across different db schemas

[Daniel72]

I'm currently playing around with EA's database modeling capabilities.

My database has three different schemas BASE, SCHEMA1 AND SCHEMA2 (just as an example)

In EA I have created a package for each of them inside one particular view (type is Class). Underneath of BASE, there is a table T1, which is referenced from the other schemas (SCHEMA1.T2 and SCHEMA2.T3) via FK. For this, I have put a simple link to BASE.T1 onto the SCHEMAx diagrams, have created an appropriate relationship and the corresponding FK. But EA seems not to distinguish between the different schemas (already in the Foreign Keys dialog). When I generate the package SQL, the T1 table is never qualified with BASE so the resulting SQL is wrong.

My question is: How can I model this relationship so EA will generate afterwards the proper SQL? Or is there an other way how to model database schemas in EA?



Thanks.

Daniel