Autogenerated FK columns

Discussions about database modeling product Cameo Data Modeler functionalities

Moderator: Moderators

Autogenerated FK columns

Postby » Mon Oct 03, 2016 8:54 am

Hi folks,

I am having an issue with generating the FK names through an ER to SQL transformation.

:: I have 2 entities: Customer and Address. I wish to use the Address as a billing address and delivery address so have set up 2 foreign key relationships.
:: I have named these relationships as BillingAddress and DeliveryAddress.
:: I have set the option ''Autogenerated FK column name template" to %r within the transform process as I understand that this will take the relationship role name as the name of the FK?
:: When the transform process finishes, the FK columns take the name of the table name, i.e. Address and Address1, not BillingAddress and DeliveryAddress.

Anyone have any ideas what I am doing wrong? Any and all replies welcome.

You do not have the required permissions to view the files attached to this post.
Forum Newbie
Forum Newbie
Posts: 3
Posts Rating:0
Joined: Wed Sep 28, 2016 7:43 am

Re: Autogenerated FK columns

Postby ieva.n » Thu Oct 06, 2016 8:11 am


We saw that you have created identical question in our support system. We will reply to the issue in the ticket you have created in support system.

No Magic, Inc. Customer Support
No Magic
No Magic
Posts: 368
Posts Rating:29
Joined: Thu Aug 02, 2012 5:02 am
Full name: Ieva

Return to Cameo Data Modeler

Who is online

Users browsing this forum: No registered users and 0 guests