is there a way to create a foreign key using a referenced table NOT included in your Relational Model ?
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,
..nevermind. lmgtfy myself:
Adding foreign key REFERENCES another schema
works like a charm.