1 Reply Latest reply: Jul 12, 2013 2:12 AM by Philip Stoyanov-Oracle RSS

    Missing primary foreign key in grandchild table

    ceving

      I have a model with a two inheritance generations.

       

      https://www.dropbox.com/s/4rghqcmxx24bgvt/pf_logical.png

       

      When I engineer all entities everything is fine. The child tables get their primary foreign keys:

       

      https://www.dropbox.com/s/t4v5bexxwdrn5y1/pf_engineered.png

       

      But when I do not engineer the child generation the grandchildren have no primary foreign keys anymore.

       

      https://www.dropbox.com/s/ofl436sm8dua3w8/pf_missing.png

       

      I have expected, that the grandchildren get a primary foreign key to the grandfather. But that is not the case. How can I tell the modeler to engineer such a foreign key?