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: | |
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
[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.