1 Reply Latest reply on Apr 18, 2019 7:34 AM by unficyp

    Cross Schema Foreign Keys

    unficyp

      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