MySQL Forums
Forum List  »  MySQL Workbench

Re: one-to-n relations create logic
Posted by: Roland Bouman
Date: August 21, 2008 05:24AM

Hi Bogdan,

> In DBDesigner (and in my logic) when you want to
> create a one-to-many relation (identifying or non)
> you have to select the "one" table first and then
> the "many" table.
>
> In Workbench you have to select the "many" table
> first and then the "one" table.

It's kind of chicken/egg. I think it makes more sense to start with the table that 'owns' the foreign key constraint

> It is possible to change this behaviour ? For me,
> when creating a ONE to MANY relation, it makes
> more sense to select first the ONE table and then
> the MANY.

Please file a feature request at bugs.mysql.com to make it configurable.

>
> Thanks for the time and sorry if it has already
> been discussed !

Roland Bouman
http://rpbouman.blogspot.com/

Options: ReplyQuote


Subject
Views
Written By
Posted
5525
August 20, 2008 09:11AM
Re: one-to-n relations create logic
2639
August 21, 2008 05:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.