MySQL Bugs: #44554: Display table properties and flags in a table-like manner

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

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

Do you want column information to be presented this way on ERR Diagram? It will make table "box" wider.

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.

The control should be radio buttons of course:

o Serial Display  (as is now)
o Column Display  (future?)

Thank you for the feature request.

Duplicate of bug #38803

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.