Bug #86141 Workbench 6.3 no longer offers PKs and FKs only table v in model diagram

Submitted: 29 Apr 2017 16:44 Modified: 6 Jul 2017 18:02
Reporter: Peter Brawley (Basic Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S4 (Feature request)
Version:6.3 OS:Any
Assigned to: CPU Architecture:Any

[29 Apr 2017 16:44] Peter Brawley
Description:
Before 6.3 it did.

It's a serious usability issue.

How to repeat:
Create a model with a dozen or more tables, and try to get all relationships on screen.
[9 May 2017 2:01] MySQL Verification Team
Thank you for the bug report. I don't understand what are you reporting here, could you please provide a screenshot which shows that issue and the model project file so I will test with 6.3.9. Thanks in advance.
[9 May 2017 17:32] Peter Brawley
When a model has a score or more tables, we need a one-click method to switch between (i) seeing all columns in a sub-rectangle of the model, and (ii) seeing just table names and keys for the whole model while maintaining as much readability as model size allows; in mode (ii), adding a relationship would temporarily show all columns to pick a relationship key from. Now, getting a whole model on screen requires zooming down to unreadability, or editing model->options->diagram->max columns, which is cumbersome and not what's needed.

(Can't attach an img as requested in Contributions, apparently this isn't an open bug)
[9 May 2017 17:54] MySQL Verification Team
Thank you for the feedback. To attach a picture you use the Files tab (not Contributions) you can attach the file private if you wish). Thanks.
[9 May 2017 18:48] Peter Brawley
unreadable eer diag showing all tbls

Attachment: wb-nwib.png (image/png, text), 91.85 KiB.

[6 Jul 2017 12:01] Chiranjeevi Battula
Hello  Peter Brawley,

Thank you for your feedback.
Verified this behavior on MySQL Workbench in 6.3.9 version

Thanks,
Chiranjeevi.
[6 Jul 2017 12:01] Chiranjeevi Battula
Screenshot

Attachment: 86141.JPG (image/jpeg, text), 193.67 KiB.

[6 Jul 2017 18:02] Peter Brawley
Miguel says he does not understand the problem. 

I don't understand what he doesn't understand. Put most simply, it's that when a model has many tables, say about 20 or more, the thing becomes unreadable. We need a one-click method to switch between seeing all columns/table and seeing just PK and FK columns/table.

IIRC WB once had this., The request is to make the feature available.

------------------------------------------------------------------------

[9 May 2:01] Miguel Solorzano

Thank you for the bug report. I don't understand what are you reporting
here, could you please provide a screenshot which shows that issue and
the model project file so I will test with 6.3.9. Thanks in advance.
[24 Jul 2017 8:11] Mike Lischke
This is actually a feature request. WB never had a one click solution to hide/show columns for all tables in a diagram.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.042 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.