Converting join table to join model table

I have a join table (foos_bars) which used to just be a join table in a HABTM
relationship.

Now I want to create a FooBars model to hold extra attributes about the
relationship without losing any of the data in the table, however I can't think
of a way to add the promary key column without an error. How do I do it?

Thanks

doesn't rails add an id column anyway?

A HABTM association doesn't use an id primary key in the table
definition. The structure is similar to:

table 'table1_table2'
  t.column table1_id, :integer
  t.column table2_id, :integer

Since you're now stating you want the join to be pushed to a separate
model now, with attributes; you'll change both model definitions to
have has_many :myNewJoinyThing. The model will also have the same
association. Since it is a separate model you can add attributes as
well.

Gareth Adams wrote: