Bug #66051 Support Plural/Singular naming conventions

• Submitted: 27 Jul 2012 14:20
• Modified: 27 Jul 2012 14:41
• Reporter: Mathieu Jobin
• Status: Verified
• Category: MySQL Workbench: Modeling
• Severity: S3 (Non-critical)
• Version: 5.2.40 - rev 8790
• OS: Any
• 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.