On Mon, 2011-06-06 at 16:27 -0430, Luis Ochoa wrote:
> I'm finishing the first goal of my database designer improvement
> project http://goo.gl/21rXu and now I'm adding a new metadata
> information to relationship objects, with info about: match, on
> delete, on update and table constraint name (for fk) as shown below:
>
> REFERENCES reftable...column constraint....FOREIGN KEY ( column [, ...
> ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ] [ MATCH matchtype ]
> [ ON DELETE action ] [ ON UPDATE action ] (table constraint)
>
> There are plenty ways of doing this but I have thought about two:
>
> 1. Allow user with a right click menu over relationship object to
> select in 4 different options that allow modification of all this
> information, user click at one item and then get a dialog or something
> like that to modify what he wants.
>
> 2. Create a dialog that contains all this info in a single point, and
> then allow user to invoke this with double click in relationship or
> just selecting one option of right click menu for this purpose.
>
> Any new ideas about how to do this?
>
> I just want some feedback from community to select the best way of
> doing this.
>
I prefer solution 1. Seems quicker and more intuitive.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com