Bug #103070 Workbench diagram: missing symbol of the primary key in a child table
Submitted: 23 Mar 2021 9:17 Modified: 23 Mar 2021 10:24
Reporter: Michael Kaufmann Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:8.0.20, 8.0.23 OS:MacOS
Assigned to: CPU Architecture:Any

[23 Mar 2021 9:17] Michael Kaufmann
For visual table modelling, the primary key column is marked with a primary key symbol (yellow key).

When an identifying relationship (1:n and n:m) is added to a table, suddenly the primary key symbol is not present anymore. 

This was not the case for earlier versions (6.2) but it happens in Version 8.

How to repeat:
In Workbench Modeling:

Add table1
Add PK to table1

Add table2
Add PK to table2

Add n:m relationship between table1 and table2 => new table table1_has_table2 has no PK symbol

Add table3
Add PK to table3

Using pipette symbol, ad FK from idtable2 to idtable3
=> PK symbol of table2 disappears

Suggested fix:
You could check why the symbol is not displayed for foreign keys that are part of the primary key (identifying relationships), by analysing why the PK disappears in the last step

Please make sure the symbol is displayed also for identifying relationships
[23 Mar 2021 9:18] Michael Kaufmann
Here's an MWB file that reproduces this bug.

Attachment: testCase.mwb (application/octet-stream, text), 7.97 KiB.

[23 Mar 2021 10:24] MySQL Verification Team
Hello Michael,

Thank you for the report and model file.