Bug #45319 Improvements to Columns Tab in Table Editor
Submitted: 4 Jun 2009 5:04 Modified: 5 Jun 2009 9:16
Reporter: Sam Hummel Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version:5.1.12 beta OS:Microsoft Windows (XP Pro)
Assigned to: CPU Architecture:Any
Tags: table editor, usability, user interface
Triage: Triaged: D5 (Feature request) / R3 (Medium) / E3 (Medium)

[4 Jun 2009 5:04] Sam Hummel
Description:
(First off, a HUGE THANK YOU to whoever solved the extremely slow canvas rendering problem somewhere between 5.1 and 5.1.12 beta.  I can now use MySQL Workbench where I couldn't before!)

I'm in the process of building a large new data schema from scratch, which means I'm spending a lot of time in the Table Editor. What follows are a few wish-list suggestions that, based on my experience, would make designing tables in the table editor more user friendly and less error prone.  If there is a wonderful soul out there who enjoys working on such UI challenges, kisses in advance!

How to repeat:
see descriptions accompanying the suggested fixes

Suggested fix:
1)  Replace double-clicks with single-clicks, pretty please

    This would make a big difference given that tabbing through the cells in the grid doesn't work very well (and solving that problem is likely to be more involved).  Having to double-click in each cell to get a cursor is taking its toll on my mouse hand.

2)  Allow clicking in Column Comment field immediately after typing column name

    If you type in the column name field and then try to click in the Column Comment field while the cursor is still in the column name field, it doesn't work.  If you try to click in the Column Comment field while the cursor is in the Datatype field, it works.  A strange inconsistency that has tripped me up a number of times.

3) Allow tabbing (or arrow key navigation where possible) of the entire grid.

    I can tab from column name to the Datatype cell in a column definition, but that's it.  If I tab one more time the focus goes to somewhere that I can't figure out.  It would be great if I could tab through all the fields all the way to a new line (new column definition).  

4) Put the column comment field in the grid

    I really appreciate that the Column Comment field was given a nice big text-wrapping and scrolling window.  That really is nice when going back and editing a comment.  However, when first drilling out a comment on the keyboard, it would be great if I didn't have to go to my cursor to jump to a special input form and then jump using my cursor back to my flow of defining fields afterward.  If the Column Comment could (in addition to being in its nice little text-wrap, scrolling window) be a column in the grid (right after Default) I think that'd be great.  Here'd be my ideal: I name my column, tab, name my datatype, tab, hit spacebar to check NN, tab past AI to Default, type in a Default value, tab, type in my column comment, tab to next line for new column definition.
[5 Jun 2009 9:16] Valeriy Kravchuk
Thank you for the reasonable feature request(s).