Bug #44554 Display table properties and flags in a table-like manner

Submitted: 29 Apr 2009 18:24 Modified: 23 Aug 2009 10:18
Reporter: Karsten Wutzke Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version:5.1.10 OS:Any
Assigned to: CPU Architecture:Any
Tags: display, flags, properties, table, table wise

[29 Apr 2009 18:24] Karsten Wutzke
Description:
I'd really like to see a feature which displays all table properties and flags in a table-like manner and not just as a serial string.

Name | Type | NN | UN | AI | ...

would all be left aligned within their column and the user would have a better overview. Of course, this will likely increase every table's size. To prevent this, you should offer a checkbox for each and every flag under "Tools" -> "Options..." -> "Diagram" like

# Show Column Types
# Show Column Flags
  # Show Flag NOT NULL (NN)
  # Show Flag UNSIGNED (UN)
  # Show Flag AUTO_INCREMENT (AI)
  # ...

The Sub-Flags should be greyed out according to the "Show Column Flags" check.

How to repeat:
-

Suggested fix:
See description
[30 Apr 2009 6:25] Valeriy Kravchuk
Do you want column information to be presented this way on ERR Diagram? It will make table "box" wider.
[30 Apr 2009 16:16] Karsten Wutzke
Yes, it will be wider. Not everyone might like this of course. It's probably best to have an option somewhere under "Tools" -> "Options..." -> "Diagram" or so.

e.g. check boxes

# Serial Display
# Column Display

I nontheless think having the choice of what to display as flags etc. is a great option. For example I don't really care about unsigned or auto_increment. These are independent of this issue.
[30 Apr 2009 16:19] Karsten Wutzke
The control should be radio buttons of course:

o Serial Display  (as is now)
o Column Display  (future?)
[14 May 2009 8:14] Valeriy Kravchuk
Thank you for the feature request.
[21 Aug 2009 10:57] Alfredo Kojima
Duplicate of bug #38803
[21 Aug 2009 15:29] Karsten Wutzke
The classification as a duplicate is wrong. I was talking about the "diagram view", not the "edit table view". I'd simply like to see the flags visually aligned when rendered on the diagram view. Thus, this is not a duplicate.

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

Page generated in 0.056 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.