How do I create a migration with two fields that reference the same table? I have tables A, and image. A.image1_id will reference image, and A.image2_id will reference image also. There are only 2 images, not many. If I use
class AddFields < ActiveRecord::Migration
def change
change_table(:ticket) do |t|
t.references :image1_id
t.references :image2_id
end
end
end
I don't think that will work because it will add another _id to the end and probably won't know to use the 'image' model. I also thought about
change_table(:ticket) do |t|
t.references :image
But then how do I add two of those? I also thought about adding
create_table :images do |t|
t.belongs_to :ticket
t.string :file
But I only want 2, not many, and this doesn't appear to allow getting to the image from the ticket, like ticket.image1
or ticket.image2
.
According to this documentation http://apidock.com/rails/v3.2.8/ActiveRecord/ConnectionAdapters/SchemaStatements/change_table which is all I could find, t.references doesn't appear to take any arguments either.
change_table(:suppliers) do |t|
t.references :company
end