Association Name not displayed if Foreign Key

[Paolo F Cantoni]

If you have an edge between two tables and there is a Foreign Key Constraint, the Edge Name is NOT displayed.  This is because Foreign Key constraint field mapping is displayed in that label (Middle Top).  If no Foreign Key is yet defined, the Edge Name is displayed.

This is inconsistent with other uses.  The Foreign Key constraint could be displayed in the Middle Bottom label and that would allow the Edge Name to be consistently displayed in the Middle Top label.


NOTE: if you reverse engineer a Foreign key relationship, the Middle bottom label is blank.  If you create one, it contains the string: «FK»  - but that's another story (but should still be fixed).

There's also a synchronization problem with the on-screen display when you add the Foreign Key constraint and when you refresh the diagram - but that's yet another story (but should still be fixed).

Next, when you delete the Foreign Key constraint it will (at no charge) delete the Edge Name (even though the displayed label (Foreign Key constraint) has NO relationship to the Edge Name).  This one has to be FIXED!

Nonetheless, if a name IS specified, it should be displayed.

A side effect of this is that when you suppress line segments, you DON'T get the edge name at either end of the suppressed line segment (as you do with other renderings).  You get the Foreign Key Constraint which may not be unique enough (and which you can't change).  Which is how I discovered the 5 bugs above in the first place...

Reported,
Paolo

[«Midnight»]

There have been several oddities relating to how connections and labels thereof are displayed in data diagrams. I've reported some in the past, with limited effect.

For an entertaining experience, try setting up a data model using UML notation. Include some foreign keys. Then use the Diagram Properties dialog to change the connector notation, view the diagram, then change the connector notation back. Try several combinations.

[Paolo F Cantoni]

There have been several oddities relating to how connections and labels thereof are displayed in data diagrams. I've reported some in the past, with limited effect.

For an entertaining experience, try setting up a data model using UML notation. Include some foreign keys. Then use the Diagram Properties dialog to change the connector notation, view the diagram, then change the connector notation back. Try several combinations.

That's exactly how I diagnosed the bug!  The report started off as a different analysis.  But playing around as you suggest finally showed me where the issue was...

Paolo