Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have used workbench before to make databases code wise and I just started looking into its EERD functions. I created a small database for a test project and found some odd things about how MySQL workbench did things. I am trying to make sure this program is working correctly before I use it for larger projects.

I created an EERD that looks like this:


I forward engineered it to my database and it went through fine, everything seems to look ok (don't have data to test it with). I then reverse engineered that database and it switched all of the optional manys into mandatory(1) manys.

Is this a cosmetic issue with workbench or can I not forward engineer optional manys?

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.