Mysql – What does a round relationship icon mean in MySQL Workbench Visual Data Model

MySql Workbench is powerful, but not perfect.

Some time in similar case, I've done the following to resolve the problem:

• create a blank project
• require a model update FROM db source
• then I'll reapply the mod.

Often this happen if you just change a 'comma' [a small thing] in the db without sync it with the model, and then you change another 'comma' in the model. MySql Workbench goes crazy often as db increases in complexity and table number, but I think it's a very good product.

From the MySQL Workbench 5.2 window, select Database -> Synchronize model which will allow you to synchronize the model (EER diagram) with the database (you need to create a saved connection) for it.

I recommend this method over just reverse engineering the model from the database since it maintains the layout of the EER diagram. One caveat is that you need to add new tables to the EER diagram manually.