Bug #54172 An icon for when a key is both a PK and a FK

• Submitted: 2 Jun 2010 8:24
• Modified: 14 Jan 2014 5:20
• Reporter: Michael Garcia
• Status: Closed
• Category: MySQL Workbench: Modeling
• Severity: S4 (Feature request)
• Version: 5.2.21
• OS: Any
• CPU Architecture: Any
• Tags: foreign key, icon, interface, primary key, usability

[2 Jun 2010 8:24] Michael Garcia

Description:
We should have an icon that indicates when a key is both a primary key and a foreign key.

How to repeat:
...

Suggested fix:
We have a red diamond for FKs and a yellow key for PKs

I suggest a red key, or just use the two icons together

[2 Jun 2010 8:36] Susanne Ebrecht

Many thanks for writing a feature request.

This is a very common use case in 3NF modelling.

For example:
[table a(i INTEGER PK, ...)] --- 1:N --->
[table b(i INTEGER, j INTEGER, ... PK(i,j), FK(i) ref a(i), FK(j) ref c(i)] <--- N:1 --- [table c(i INTEGER PK, ...)]

[14 Jan 2014 5:20] Philip Olson

Fixed as of the upcoming MySQL Workbench 6.1.1 release, and here is the changelog entry:

With modeling, a red key now indicates that a key is both a PK and FK.
This coincides with a red diamond representing FKs, and a yellow key for
PKs.

Thank you for the bug report.

[20 Jan 2017 19:57] Christopher Phillips

This is NOT fixed in the current MAC build. (6.3.8 build 1228)

[5 Apr 2017 22:48] Joy Niu

Does anybody know that if this problem fixed in mac version 6.3.9? Thanks a lot!

[5 May 2017 1:08] Stas Trefilov

still not fixed in mac build 6.3.9

[16 Nov 2017 16:49] Martijn Groeneveldt

still does not work with the latest version on Mac while one release down has it working