Book a Demo

Author Topic: foreign keys using inherited columns  (Read 3423 times)

p_d_austin

  • EA Novice
  • *
  • Posts: 7
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
foreign keys using inherited columns
« on: February 01, 2006, 03:28:01 pm »
In the PostgreSQL db you can define a table to inherit from another table. In this scenario the primary key of the table will normally be defined in the super table definition and then inherited by the sub tables.

In EA 6.1 the Foreign Keys... dialog on an association does not show the inherited columns so you have to duplicate the columns in each of the sub tables.

It would be useful if the list could show the inherited columns in the foreign key dialog.

Cheers,
Paul