Bug #67796 PK flag does not appear on entity-relationship diagram
Submitted: 3 Dec 2012 11:38 Modified: 31 Jan 2018 9:16
Reporter: John Coleman Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.44 OS:Linux (Linux 3.0.48-1-lts)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[3 Dec 2012 11:38] John Coleman
Description:
PC flag does not appear on entity-relationship diagram

----- Developer Notes -----

MySQL Workbench CE for Linux/Unix version 5.2.44  revision 9933
Configuration Directory: /home/john/.mysql/workbench
Data Directory: /usr/share/mysql-workbench
Cairo Version: 1.12.2
OS: Linux 3.0.48-1-lts
CPU: AMD Athlon(tm) 64 Processor 3500+ 2210.713 MHz, 2.9 GB RAM

How to repeat:
Place a New Table (Quick key - press T)
Diagram shows table1 with its only column, idtable1 INT, flagged NN - but not PC !
[3 Dec 2012 11:40] John Coleman
oops, for PC read PK - sorry
[3 Dec 2012 11:43] John Coleman
Place a New Table (Quick key - press T)
Diagram shows table1 with its only column, idtable1 INT, flagged NN - but not PK !
[3 Dec 2012 15:23] MySQL Verification Team
I can't repeat on CentOS 6.3. However when creating a second table the column don't has even the NN so I need to change for another tab (Indexes for exmple) and when back to tab Columns the PK and NN are checked.
[3 Dec 2012 17:37] John Coleman
Hi Miguel,
FYI I am using Arch Linux.
In my case the Columns tab shows PK and NN as checked, correctly.  But in the diagram the entity attribute, idtable1, is not flagged as the primary key by a PK suffix, or even by (PK), which would be just as good - it just shows idtable1 INT NN.

It is very important to show which attribute is an entity's primary key in the entity-relationship diagram.

I have a screen-shot but I don't know hot to attach it.
[3 Dec 2012 17:40] John Coleman
Unflagged primary key in entity-relationship diagram

Attachment: mysql-workbench-pk-flag.png (image/png, text), 18.21 KiB.

[28 Dec 2012 13:10] MySQL Verification Team
Please try version 5.2.45. Thanks.
[29 Dec 2012 19:18] John Coleman
PKs not flagged in entity-relationship diagram at Version 5.2.45 rev 10251

Attachment: mysql-workbench-pk-flag2.png (image/png, text), 112.19 KiB.

[21 Mar 2013 20:55] Armando Lopez Valencia
Thanks a lot for your report.
There is no PK identifier in the "Classic" Diagram view (Model->Object Notation->Classic).
[22 Mar 2013 13:19] John Coleman
Hi Armando,
thanks - don`t tell me "It`s not a bug, it`s a feature.".

What kind of `Classic` ERD shows foreign keys but not primary keys ?

But your comment is helpful - I will switch to IDEF1X as a workaround.

John
[31 Jan 2018 9:22] Mike Lischke
Actually, this is behavior by intention. Each notation has a concept for various information. The classic notation doesn't have any explicit PK flagging. Other notations have that (like a different icon or a separation line). So, if you need that use something else but the classic notation.