How to Model a table with two foreign keys of the same table

Rails
1

Hi the following table

JobOrder: fields(id, date_filed, date_needed, request_by, process_by,
details, date_finished)
Employee(id, name)

the request_by and the process_by field are the foreign key of the
table emplyee.

How will the model look like?

class Joborder < ActiveRecord::Base
belongs_to :employee, :class_name => “Employee”, :foreign_key = >
“request_by”
belongs_to :employee, :class_name => “Employee”, :foreign_key =>
“process_by”
end

Is the model above the correct way?

Thanks

2

i think they should have different names
…
belongs_to :employee1, …
belongs_to :employee2, …
…
the mapping is done through the class_name and the foreign_key

3

P. Pantouffe wrote:

i think they should have different names
…
belongs_to :employee1, …
belongs_to :employee2, …
…
the mapping is done through the class_name and the foreign_key

Only thing I’d add is more sensible variable names (which is implied, I
think).

class Joborder < ActiveRecord::Base
belongs_to :requestor, :class_name => “Employee”, :foreign_key = >
“request_by”
belongs_to :processor, :class_name => “Employee”, :foreign_key =>
“process_by”
end

This will let you do @job_order.processor… or @job_order.requestor…

A.