Proposing a change to use a self-join in the assignments table

as seen in http://guides.rubyonrails.org/association_basics.html#the-has_one-through-association  section 2.10