Take the 2-minute tour ×
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. It's 100% free, no registration required.

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:

(User)||---o<(Permissions)>o---||(Rooms)||---o<(Posts)||---o<(Target)

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

 
discard

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

Browse other questions tagged or ask your own question.