Display foreign keys in the data modeler

Ralph Ashley

Hi,

Is this a bug or am I doing something incorrectly?

Steps taken:

1. Drag table base.vessel_registration and 2 other related tables.
2. the foreign keys display automatically. Which is what I expected.
3. I then drag params.vessel_type onto the diagram
4. No foreign key join appears even though a foreign key exists (vesr_vest_fk(vesr_vest_id_fk)) in the table as shown below in the base.vessel_registration table. NOT WHAT I EXPECTED.

   So am I missing something or is this a bug?

   
   

   

   
   

Philip Stoyanov-Oracle

I'll recommend to use DM import functionality or even to switch to standalone version of DM. The picture shows that you are mixing tables from different models or model and directly from database. Your life will be simpler with standalone DM.

Philip

Ralph Ashley

Hmmmm,

I pulled base.vessel_registration from the database while I pulled params.vessel table from the model browser.

I still can't get my head around the difference since I just pulled all tables from the DB to a new rel.model.

Seriously, considering moving back to designer, now... :(

Philip Stoyanov-Oracle

I'll recommend to use DM import functionality or even to switch to standalone version of DM. The picture shows that you are mixing tables from different models or model and directly from database. Your life will be simpler with standalone DM.

Philip

Ralph Ashley

Just in case someone else reads this I just want to be clear in that the problem was my importing the tables from different sources, one was directly from the DB while the other was from the list of relational tables.

Solution:

1. Get the tables from the same source.
2. I will be installing the stand alone version of DM.