# How specify foreign key column name in model?

**URL:** <https://www.ruby-forum.com/t/how-specify-foreign-key-column-name-in-model/116612>\
**Category:** Rails\
**Created:** [October 7, 2007, 11:58pm UTC](https://www.ruby-forum.com/t/how-specify-foreign-key-column-name-in-model/116612 "2007-10-07T23:58:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bazsl](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/ad7895/32.png) [@Bazsl](https://www.ruby-forum.com/u/Bazsl)\
**Post date:** [October 7, 2007, 11:58pm UTC](https://www.ruby-forum.com/t/how-specify-foreign-key-column-name-in-model/116612/1 "2007-10-07T23:58:22Z")

</div>

In a model declaration I can specify the name of the primary key  
column with

set\_primary\_key “CUSTOMER\_NUMBER”

How can I set the name of a foreign key column that does not conform  
to the RoR naming convention. Does the following work?

set\_foreign\_key “CUSTOMER\_NUMBER”

If not, how can I specify the name of the foreign key column? Thanks.

---

<div class="post-metadata">

**Author:** ![Bazsl](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/ad7895/32.png) [@Bazsl](https://www.ruby-forum.com/u/Bazsl)\
**Post date:** [October 8, 2007, 12:23am UTC](https://www.ruby-forum.com/t/how-specify-foreign-key-column-name-in-model/116612/2 "2007-10-08T00:23:03Z")

</div>

Ignore the question. I found the answer.

---

<div class="post-metadata">

**Author:** ![Bazsl](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/ad7895/32.png) [@Bazsl](https://www.ruby-forum.com/u/Bazsl)\
**Post date:** [October 8, 2007, 12:24am UTC](https://www.ruby-forum.com/t/how-specify-foreign-key-column-name-in-model/116612/3 "2007-10-08T00:24:58Z")

</div>

Use the :foreign\_key option for your has\_many/has\_one/habtm declaration.