Forum Stats

  • 3,782,248 Users
  • 2,254,622 Discussions


Recursive FK

We are having a problem with data modeller when handling a recursive relation.

As an example:

Here the FK attribute has been renamed via SQL Developer to supervisorid. When this is engineered to a relational model. this first time the renamed FK is shown as the original name:

If you engineer a second time, the FK now has the correct name:

This has not been our experience up to to 20.2, it is the case in 20.4 and 21.1