modifing db

Mk 27 wrote:

If I am going to build a sql database for use in rails (rather than
building it in rails), is there anything I need to know beyond using an
id column in every table? Does the id need to be the "primary key"?

By convention, rails would look for an id as a primary key for all
tables. Also, if you use rails migrations to generate the tables, you
can say -
create_table(:table_name, :id => false) if you don't want id.
This might be required in case your table is from a legacy system.