Option to hide "common" fields

[GoogleCodeExporter]

(new feature request)

This option could be materialized as a checkbox.

"common" fields are rows that are not part of a primary nor a foreign key 
constraint.

This is very usefull with... large databases... since the model is then 
lighter.

For example :
 Table
 - id_table // PK
 - id_owner // FK to table OWNER
 - description // text
 - last_modified // date

Becomes when hiding "common" fields :
 Table
 - id_table // PK
 - id_owner  // FK to table OWNER

Original issue reported on code.google.com by geompse@gmail.com on 16 Mar 2010 at 7:08

[GoogleCodeExporter]

This makes some sense, but I am afraid that mentioned behavior would actually
*confuse* most of users. Please propose some accessible implementation (maybe 
some
screenshot showing the checkbox location?).

Original comment by ondrej.zara on 17 Mar 2010 at 8:18

[GoogleCodeExporter]

Something like this ? This could be more documented in the Wiki...

Original comment by geompse@gmail.com on 17 Mar 2010 at 10:00

Attachments:

• okrf.png

[GoogleCodeExporter]

I am not sure this kind of option is enough. Think about the behavior: with this
option checked, clicking "add field" has *no* visual feedback, which is VERY
confusing to user!

Also note that options are saved to cookie, so if you open wwwsqldesigner 
later, you
might find out that this "feature" is enabled without you actually enabling it 
:)

Original comment by ondrej.zara on 18 Mar 2010 at 8:02

[GoogleCodeExporter]

If anything, this should be a "live" option that should be accessible from the 
main menu, not hidden within 
Options menu. And it should always default to "off", and should perhaps turn of 
when it would obscure visual 
feedback for most recent user action -- such as adding a field.

Original comment by ober.14@osu.edu on 28 Mar 2010 at 4:15

[GoogleCodeExporter]

true

Original comment by geompse@gmail.com on 29 Mar 2010 at 8:14