Skip navigation links

MySQL Forums :: MySQL Workbench :: Drawing relationships between tables in Workbench


Advanced Search

Re: Drawing relationships between tables in Workbench
Posted by: sam williams ()
Date: August 16, 2005 03:37PM

Hi Mike, thanks for posting this thread. One reason that people would like this type of daigrammatic representation has to do with the type of table storage they are using with MySql. If you look at the constraints for "Foreign Keys", you'll see that both tables must be stored of type InnoDB. In the development organization that I represent we are currently only using the MyISam storage engine. Changing the table handler just to be able to use foreign keys wouldn't get us a good return since we are able to create references between fields in two different tables currently. The addition of foreign keys would also have the downside of requiring that we alter all our existing database designs, because of the addition of an unexpected field. We would just like the ability to create new table relationships with a visual paradigm that supported this design method, as well as, having the ability to analyze existing databases and express this relationship if found without demanding major architectural changes. Hopefully, this provides a little better understanding of why someone would request such a feature.

Thanks again for your help! Btw do we have any ETA on the alpha release of MySql Workbench?

Options: ReplyQuote


Subject Written By Posted
Drawing relationships between tables in Workbench Michael G. Zinner 08/10/2005 04:06PM
Re: Drawing relationships between tables in Workbench John Zastrow 08/15/2005 05:47PM
Colored relationships John Zastrow 08/15/2005 06:06PM
Re: Colored relationships John Zastrow 08/19/2005 07:52AM
Re: Drawing relationships between tables in Workbench Dennis Mengelt 08/16/2005 03:33PM
Re: Drawing relationships between tables in Workbench sam williams 08/16/2005 03:37PM
Re: Drawing relationships between tables in Workbench Michael G. Zinner 08/23/2005 11:05AM
Re: Drawing relationships between tables in Workbench John Zastrow 08/25/2005 08:38PM
Re: Drawing relationships between tables in Workbench sbeebe 08/30/2005 01:13PM


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.