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:
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
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)
  # ...

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.