MySQL Bugs: #103070: Workbench diagram: missing symbol of the primary key in a child table

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:	None
Category:	MySQL Workbench: Modeling	Severity:	S3 (Non-critical)
Version:	8.0.20, 8.0.23	OS:	MacOS
Assigned to:		CPU Architecture:	Any

Description:
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

Here's an MWB file that reproduces this bug.

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

Hello Michael,

Thank you for the report and model file.

regards,
Umesh