How can i create 2 foreign key in a table referring key from one table?

rubyonrails-talk
1

hi Friends, i have a accounts table and a transaction table see the schema below 1. acc_master

   `acc_id` int(11) -- primary key    `acc_name`    `cur_balance`    `regist_date`    `update_date`

2. acc_trans   `trans_id` -- primary key   `trans_from` -- foreign key reference to acc_id (acc_master)   `trans_to` --- foreign key reference to acc_id (acc_master)   `trans_date`   `trans_amount`   `trans_narration`

How can i create a migration file for the 2nd table .. how will i represent 2 foreign key from same table in Rails? Can any one help for this question please?

Thanks amjithps@gmail.com

2

How can i create a migration file for the 2nd table .. how will i represent 2 foreign key from same table in Rails? Can any one help for this question please?

belongs_to :foo_1, :class_name => 'Foo', :foreign_key => 'foo_1_id' belongs_to :foo_2, :class_name => 'Foo', :foreign_key => 'foo_2_id'

Fred

3

Frederick Cheung wrote: