Bug #78146 the default name for the first column has "id" as prefix rather than postfix

• Submitted: 20 Aug 2015 8:01
• Modified: 20 Aug 2015 8:14
• Reporter: Hanan Vinner
• Status: Not a Bug
• Category: MySQL Workbench: Modeling
• Severity: S3 (Non-critical)
• Version: 6.3.4.0
• OS: Windows
• CPU Architecture: Any

[20 Aug 2015 8:01] Hanan Vinner

Description:
Creating a model
Create a new table 'user'
now click on table columns editor empty first line.
it automatically creates a column with name "iduser"
while I expect it according to documentation to name it "userid"  (while I do think "user_id" will be better, though).

details:
1. My OS and Workbench is in english however some locale definition are hebrew (he-il) which is an RTL language - may be related to the fact we have prefix intead of postfix.
2. after the first one, the rest are named "usercol".

How to repeat:
see decription

Suggested fix:
see description

[20 Aug 2015 8:14] MySQL Verification Team

Hi Hanan Vinner,

Thank you for the report.
By default Column Defaults are "PK Column Name"->"id%table%" etc which you can change and customize as you like. These can be configured from WB->Edit->Preferences: Modeling: Defaults

Please see https://dev.mysql.com/doc/workbench/en/wb-preferences-modeling.html

SO, with "PK Column Name"->"%table%_id" setting, you may see user_id etc..

Thanks,
Umesh