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 created a model in the Visual Data Model of MySQL Workbench, and on one single relationship, this icon shows up:

Circle relationship icon

What does it mean? The Relation is 1:1, and this icon shows only on this particular relationship, none other. I already checked and the relationship is exactly the same as all the other.

share|improve this question
add comment

1 Answer

up vote 5 down vote accepted

The icon shows that that side of the relationship is not mandatory, meaning the field can be NULL. You can change that if you click on the relationship line, go to Foreign Key tab and select the Mandatory check box.

share|improve this answer
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.