Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cross Schema Foreign Keys

unficypApr 18 2019 — edited Apr 18 2019

Hi,

is there a way to create a foreign key using a referenced table NOT included in your Relational Model ?

e.g:

Relational model "core", DB Schema "core", Table "user_data", PK "id"

Relational model "ticket", DB Schema "ticket", Table ticket, Column "user_id" - should have an FK to core.user_data.id

How can i get Data Modeler to let me select the ticket table ?

Can i "connect" one or more Relational models together ?

Or do i have to "create/include" the user_data table in every model ?

thanks in advance,

gerald

Comments

Processing

Post Details

Added on Apr 18 2019
1 comment
257 views