MySQL Forums
Forum List  »  MySQL Workbench

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




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.