MySQL Bugs: #17931: Relationship cardinalities appear at the wrong (other) end

Bug #17931	Relationship cardinalities appear at the wrong (other) end
Submitted:	5 Mar 2006 11:24	Modified:	12 Apr 2006 8:23
Reporter:	Roland Bouman	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench Preview	Severity:	S2 (Serious)
Version:	1.0.5beta	OS:	Windows (win xp)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
Apparantly, the MySQL Workbench uses relationship notation similar to familiar ERD conventions. In this notation, the relationship is drawn as a line connecting the related entities, and the cardinalities for the relationship are drawn at the relaitonship end, using a particular symbolic notation.

The cardinalities appear at the wrong ends. Another way of putting it is to say that the direction of the relationship is reversed. This severly impedes the usability of the diagrams for communication purposes (which is IMO one of the advantages of drawing diagrams in the first place)

How to repeat:
Create two tables: 'P' and 'C'. add an Id primary key column on the 'P' table. Now, select the one to many relationship tool, and initiate a drag and drop action from the id column of the 'P' table to the 'C' table.

When the relationship is created, a column is created in the 'C' table to store the reference to the 'P' table as is to be expected. Also, in the table editor, a foreign key definition is created in the C table.

However, the crowfoot, indicating the many side of the relationship is positioned on the end that is attached to the 'P' table. This is wrong - the 'C' table should've been attached to the many side.

Suggested fix:
Please reverse the direction of the relationships.

Thank you for the bug report.

Bug: http://bugs.mysql.com/bug.php?id=18434 was marked as
duplicate of this one.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html