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: Verified 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

[27 Jul 2012 14:20] Mathieu Jobin
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....
[27 Jul 2012 14:41] Valeriy Kravchuk
This is a reasonable feature request: add option to recognize this kind of naming conventions for reverse engineering etc.