Forum Stats

  • 3,732,985 Users
  • 2,246,665 Discussions
  • 7,856,453 Comments

Discussions

Recursive FK

LindsayS
LindsayS Member Posts: 28 Blue Ribbon

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

Sign In or Register to comment.