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

    Cross Schema Foreign Keys



      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,