Bug #18434 1-M relationship is indicated in reverse direction
Submitted: 22 Mar 2006 19:38 Modified: 23 Mar 2006 1:20
Reporter: [ name withheld ] Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Preview Severity:S3 (Non-critical)
Version:MySQL Workbenc 1.0.5 Beta OS:Windows (Windows XP Pro SP2)
Assigned to: CPU Architecture:Any

[22 Mar 2006 19:38] [ name withheld ]
Description:
The one to many relationship between tables is indicated in reverse direction. The "many" side of relationship (indicated usually as a crow's feet) is shown on the entity with "one" (or single) instance. 

Instead of indicating a one to many relationship as

       +-------+                    +---------+   
       |          |                 /  |            |
       |  ONE  |---|---------|---|   MANY  |
       |          |                 \  |            |
       +-------+                    +---------+

it is indicated as 

       +-------+                   +---------+   
       |          | \                 |            |
       |  ONE  |--|----------|-- |   MANY |
       |          | /                 |            |
       +-------+                   +---------+

Also, the ordinality (mandatory or optionality) of the relationship is not indicated.

How to repeat:
Just draw up a model or reverse engineer from a database that has a one-to-many relatioship and the cardinality reversal shows up in the model.
[23 Mar 2006 1:20] MySQL Verification Team
Thank you for the bug report. Duplicate of bug:
http://bugs.mysql.com/bug.php?id=17931