MySQL Bugs: #66051: Support Plural/Singular naming conventions

Bug #66051	Support Plural/Singular naming conventions
Submitted:	27 Jul 2012 14:20	Modified:	27 Jul 2012 14:41
Reporter:	Mathieu Jobin	Email Updates:
Status:	Won't Fix	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S3 (Non-critical)
Version:	5.2.40 - rev 8790	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	plurar singular table foreign key naming convention

Description:
more and more ORM and systems such as Rails or CakePHP supports or strongly recommend to respect a naming convention where tables are plural as they contains many rows and foreign keys are singular as they point to one row.

So we get things relations like ... order_id = orders.id

How to repeat:
when creating a new model in Workbench, or when reverse engineering one from a MyISAM database.
it would be useful that FK could be detected from this naming convention.

right now, I have to add all the relations between the tables and Workbench adds a new foreign_key into the table. duplicating them.... if at least, I could specify that the column already exist... I'm thinking clicking on the column to create the relation would make sense....

This is a reasonable feature request: add option to recognize this kind of naming conventions for reverse engineering etc.

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.