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.
Thanks